Wait msgbox in macro.

[prajul89]

Hi,

how to display a msgbox like object with text as "Please wait" while macro is running with no buttons on it and disappears after a certain codes.

 

[VoG]

Here is one way http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/

 

[Craigjre]

You should create at userform which you can show and hide at any given point in your code by

Userform1.show

Code

Userform1.Hide

you may have to put DoEvents command in your code so as the userform will show correctly

 

[prajul89]

So one has to use User forms? Is there no other way like msgbox or inputbox??

 

[Craigjre]

I do not believe you can show a messagebox without at least an OK button, in which case you don't have control over when that messagebox will disappear... Userforms are surprisingly easy to make and run though!

 

[prajul89]

Thanks for the Inputs.

 

[prajul89]

I have created a form as you guys said to, But when I execute the code to show that userform "userform.Show" the Codes are being stopped. Unless I click [close] in the userform the macro is stopped. What is the wrong thing I am doing??

 

[Weaver]

If you need to run code whilst the userform is displayed, make sure the showmodal property of the form is set to false.

 

[prajul89]

Thanks a lot!!!! it worked