Robert Crandal wrote:
"witek" wrote

You can try that:

a) set a global variable to true in userform_initialize


Hi witek..... if I set my global variable to true in
Userform_Initialize(), won't this leave the possibly of
that variable being set to true even when the userform
is NOT actually visible?

I mean, if I run the following code then the variable
will be set to true while the form is not even visible:

' This code will run Userform_Initialize and
' cause my global variable to be set to true
'
if (Userform.Visible = true) then
' My code here
end if

If I set my global variable to true in Userform_Initialize(),
should I set it to false in Userform_Terminate()?




so do not use show. use your own code to show it at keep status somewhere.


load userform1
userform1.MyShow
unlaod userform1


and write myshow as part of userform1 with .show in it.