Create VBA Function/Sub programatically within Excel VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rael_lucid - 28 Sep 2007 02:14 GMT

Hi,

Is it possible to create a VBA function or subroutine within Excel VBA?

ie: I have a spreadsheet which has a number of functions in it. One of the
functions involves creating a new spreadsheet (in a new file), based on some
of the data in the original sheet. I now need to include a function in this
new spreadsheet.

Is this possible?

Rael

Reply to this Message

mark - 28 Sep 2007 03:34 GMT

yes, look at Chip Pearson's site

www.cpearson.com

under "Programming to the VBE"

He has a nice page on how to add code to your files, through code.

> Hi,
>
[quoted text clipped - 8 lines]
>
> Rael

Reply to this Message

rael_lucid - 28 Sep 2007 08:51 GMT

Thanks Mark... the resource looks excellent.

Rael

> yes, look at Chip Pearson's site
>
[quoted text clipped - 3 lines]
>
> He has a nice page on how to add code to your files, through code.

Reply to this Message