Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically create procedures in a sheet module
Hi all,
Does anybody here know how to dynamically create procedures in a sheet module without using the troublesome InsertLines or CreateEventProc methods? If the procedures are located in a standard module then I can always use a CopyModule approach thus bypassing those troublesome methods, but can I do the same with sheet modules? Thanks for your advice in advance. Frederick Chow Hong Kong. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically create procedures in a sheet module
Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm Frederick Chow wrote: Hi all, Does anybody here know how to dynamically create procedures in a sheet module without using the troublesome InsertLines or CreateEventProc methods? If the procedures are located in a standard module then I can always use a CopyModule approach thus bypassing those troublesome methods, but can I do the same with sheet modules? Thanks for your advice in advance. Frederick Chow Hong Kong. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Your link is not relevant to my problem
Thanks for your response, but I am afraid this page can't solve my problem.
"Dave Peterson" wrote in message ... Check out Chip Pearson's site: http://cpearson.com/excel/vbe.htm Frederick Chow wrote: Hi all, Does anybody here know how to dynamically create procedures in a sheet module without using the troublesome InsertLines or CreateEventProc methods? If the procedures are located in a standard module then I can always use a CopyModule approach thus bypassing those troublesome methods, but can I do the same with sheet modules? Thanks for your advice in advance. Frederick Chow Hong Kong. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calls from sheet module to ThisWorkbook module | Excel Programming | |||
Dynamically create a formula in Sheet B referencing SheetA | Excel Programming | |||
two procedures in the same sheet one a workbook even procedure | Excel Programming | |||
Calling Procedures from another excel sheet by passing objects | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |