Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically run macro when userform is opened
basically
sub userform_open() call macro1 end sub this is not correct but demonstrates what i am attempting to accomplish |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically run macro when userform is opened
Use the Initialize event...
Private Sub UserForm_Initialize() Call Macro1 End Sub -- Rick (MVP - Excel) "jason" wrote in message ... basically sub userform_open() call macro1 end sub this is not correct but demonstrates what i am attempting to accomplish |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically run macro when userform is opened
are you trying to trap the userform opening or do you want the code run when
the userform opens? For the latter you could use the form's initialise event there's nothing else that I'm aware of, though I susoect that there's sopme API that might work. "jason" wrote: basically sub userform_open() call macro1 end sub this is not correct but demonstrates what i am attempting to accomplish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run a macro automatically when the file is opened? | Excel Discussion (Misc queries) | |||
a macro that runs automatically when a workbook is opened | Excel Programming | |||
Have macro run automatically as soon as excel is opened. | Excel Programming | |||
Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) | |||
Automatically launch a macro when a fil is opened | Excel Discussion (Misc queries) |