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!