| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create VBA Function/Sub programatically within Excel VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create VBA Function/Sub programatically within Excel VBA
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. "rael_lucid" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create VBA Function/Sub programatically within Excel VBA
Thanks Mark... the resource looks excellent.
Rael 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Function using Excel VBA | Excel Programming | |||
| How Do I Create an Excel 2007 Workbook Programatically | Excel Programming | |||
| create a discount function in excel | Excel Programming | |||
| How do I create a ratio function in Excel? | Excel Worksheet Functions | |||
| Mapland Excel Addin - Programatically Create 1000 distinct maps | Excel Programming | |||
Linear Mode
