Temporary Popup Window

zotee98 · Jan 31st 2007

i was wondering how to make a window popup automatically when a macro is running and then close itself when the macro is done. thanks in advance.

RicoSimp · Jan 31st 2007

Re: Temporary Popup Window

Hi,

Could you not just use?

Code

Sub Macro1
myForm.Show
'enter your code here
myForm.Hide
End sub

Rico.

**Andy Pope** · Jan 31st 2007

Re: Temporary Popup Window

Make sure the userform is not modal, otherwise your code will not run until the userform is closed.

[vba]Sub Macro1()
myForm.Show vbModeless
'enter your code here
MsgBox "Doing it"
myForm.Hide
End Sub
[/vba]

zotee98 · Jan 31st 2007

Re: Temporary Popup Window

Thanks Guys Worked Like A Champ

zotee98 · Jan 31st 2007

Re: Temporary Popup Window

one problem i am having now is the box shows up white. its like it doesnt get loaded before the macro runs and then is whited out.

**Andy Pope** · Feb 2nd 2007

Re: Temporary Popup Window

What code have you got exactly?

Participate now!