Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Status
Does anyone know what code to use to see if a userform is showing or if a
macro is running? Basically I would like to know how to write the following if then statements: ------ If userform1.show=true then End if ------ If macro1 is running then End if ------ Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Status
You could create global variables in your code and set them when the form is
activated, and unset when it is hidden or unloaded. Similarly for a macro. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Noah" wrote in message ... Does anyone know what code to use to see if a userform is showing or if a macro is running? Basically I would like to know how to write the following if then statements: ------ If userform1.show=true then End if ------ If macro1 is running then End if ------ Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
display status bar value in excel userform? | Excel Discussion (Misc queries) | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Need a msg box that displays time status or loading status | Excel Programming | |||
How to use the Status Bar in a UserForm | Excel Programming |