Run UserForm Invisible

[RobC]

I have a UserForm for User Input and it is PreLoaded with the Previous
Input (which I store on the Worksheet) when Initalized and this all works
fine. There are times I run this form in the background (basically
initialize it and then execute my "Generate Configuration" button which
closes it and generates a congifuration. All works well except a white
blank the size of the form appears for a short time. I have
Application.ScreenUpdating=False but I guess that gets cleared when I do a
userform.show. Is there any way to run this form truly invisible?

Thanks, Rob

 

[Jim Cone]

Try...

UserForm1.Hide
DoEvents
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"RobC" <[email protected]>
wrote in message
I have a UserForm for User Input and it is PreLoaded with the Previous
Input (which I store on the Worksheet) when Initalized and this all works
fine. There are times I run this form in the background (basically
initialize it and then execute my "Generate Configuration" button which
closes it and generates a congifuration. All works well except a white
blank the size of the form appears for a short time. I have
Application.ScreenUpdating=False but I guess that gets cleared when I do a
userform.show. Is there any way to run this form truly invisible?

Thanks, Rob

 

[RobC]

That didn't seem to work, still appears... I decided to change the Height
and Width to 0 then put it back to normal size when done. It doesn't
totally go away but is less intrusive. Thanks for the help... Rob