Clearing a UserForm

[Giordano Bruno]

I have a UserForm called Menu. The first line of code behind the OK button says

Menu.Hide

When I run this using F8, it behaves itself and the menu disappears after the code line Menu.Hide. When I click the OK button to run it normally the menu stays on the screen partially hidden behind the next sub menu.

Does anyone have any idea what I may be doing wrong?

 

[jindon]

Aren't you setting ScreeUpdating to False?

If so, set it back to True

 

[Giordano Bruno]

Hi Jindon,

Thanks for the thought. I wondered that and set it to true on the previous line, but it doesn't alter the odd behaviour.

 

[Gates Is Antichrist]

Is the subform modal? If you hit F8 then F5 does it reappear? I suspect F8 is deceiving you into thinking it's hidden.

 

[jindon]

Hummm

Have you tried Unload Menu
?

 

[Giordano Bruno]

Hi, GIA. Well, The next form is actually an InputBox.

jindon. Unload doesn't work either.

Any more suggestions?

 

[jindon]

What timing are you hiding Menu?

InputBox may take precedence over UserForm.

 

[Giordano Bruno]

Hi jindon,

I don't quite understand the reply. If by timing you are refering to sequence of events, the Menu Hide/Unload commands go before the InputBox which is in another macro called from the first. Does that anwer the question or have I missed something?

 

[jindon]

So, Menu.Hide is not working for some reason...

Does it hide after InputBox disappear?

 

[Giordano Bruno]

Yes Jindon. Whether I click OK or Cancel on the Input box the UserForm disappears instantly.

If I run it using F8, it has disappeared long before the input box arrives.