| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Procuedure to Userform
Thanks everyone that has given me some ideas.
-- Cheers Nigel "Tushar Mehta" wrote in message om... In article , nigel- says... I have a userform that is called from a worksheet event. On initialising I wish to run a procedure held in a standard module, the procedure changes depending on the value of the worksheet event. How do I pass the name of the procedure to the userform initialise event ? Check out the Application object's Run method. It accepts the name of the procedure to call as a string argument. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing variables between Sub and Userform | Excel Programming | |||
| Passing variables from module to userform | Excel Programming | |||
| Passing Userform as an argument to a procedure | Excel Programming | |||
| Userform and passing date values | Excel Programming | |||
| Passing a value to a variable from Userform | Excel Programming | |||
Hybrid Mode
