Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
detect userform
Hi
I have a modeless userform which i want to unload before i run a macro I am using the following code: if myform.visible then unload myform else 'do nothing end if if the form was loaded then it is immediately unloaded - no problem however, if the form was not loaded then the code above forces the myform.initialize to run (and then nothing happens). No damage done but it seems there is probably a better way? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyway to detect a new page | Excel Programming | |||
Detect Cell Changes | Excel Programming | |||
How to detect last row of Selection? | Excel Programming | |||
What event to detect click on UserForm ListBox? | Excel Programming | |||
Detect Outlook | Excel Programming |