How to close a userform. My userform does not close right away.

[welchs101]

I have a macro which has a userform to collect data from the user. I have screenupdating turned off to speed up code. However, i turn the screenupdating on just prior to calling the userform and then turn it off just after the userform is "supposed" to be closed and unloaded.

My issue is that I unload the userform but for some reason it still shows up on the screen.

Please Login or Register  to view this content.

the above is how to remove from memory and close the userform xyz..........right?

Any ideas?

[welchs101]

when the "OK" button is pressed here is the code that is supposed to be run.

Please Login or Register  to view this content.

[Bob Phillips]

It is. But what is the code that launches the form, including the screenupdating bit.

[welchs101]

i launch the form using this command

Please Login or Register  to view this content.

i placed screen updating around this as shown below and it still did not help.

Please Login or Register  to view this content.

[Bob Phillips]

I am confused, I cannot reproduce the problem here.

[welchs101]

well, i dont know why but this works........

so i assumed that my problem is that somehow i am not updating the screen as i should so while i turned on the updating of the screen prior to calling the userform i decided to put this in my code (see below). Here i am turning on updating just prior to unloading the form........

THIS SEEMS TO WORK.........i dont know why ........i really dont why turning on screen updating prior to showing userform doesnt work but this did..........

Please Login or Register  to view this content.