Please wait window (VB)

[WBoardman]

Hi All,

I would like to know If there is a piece of code that can display a "Please wait" dialougue box while my Macro is thinking!
I know you can put text in the status bar, but I'd like a pop up window so its obvious somthing is happining. (So they dont start pressing buttons and closing stuff etc)

Many Thanks in Advance

Wayne :D

 

[phantom1975]

You can create a UserForm that will pop up. You can even put a ProgressBar control in it to fill up as the macro executes. At different spots in your macro put something like ProgressBar1.Value = .1 then .2, etc.[/code]

 

[lenze]

Also, check out Aaron Blood's "Please Wait_Zip" at
http://www.xl-logic.com/pages/vba.html

 

[WBoardman]

Thanks for the Super Quick Reply Phantom,

As a reletive newbie to VB, can you (Or anyone) recomend a website to set me on my way. Or if someone is kind enough to post some sample code and instructions that would be fab!!!!!

Cheers!!!!

 

[phantom1975]

Start off by creating a UserForm. Then you need to right-click on the Control Toolbox that appears and select ADDITIONAL CONTROLS. Add MICROSOFT PROGRESSBAR CONTROL. Add this new control to your UserForm. Then use the following code to give you an example:

    MsgBox "Step 1 of 4 complete"
    ProgressBar1.Value = 25
    MsgBox "Step 2 of 4 complete"
    ProgressBar1.Value = 50
    MsgBox "Step 3 of 4 complete"
    ProgressBar1.Value = 75
    MsgBox "Step 4 of 4 complete"
    ProgressBar1.Value = 100
    MsgBox "You are done!"

 

[WBoardman]

Cheers Guys!!!!

Both are supurb answers, hope others find it just as usefull