message: Just a minute, please... (VB EXCEL)

[rudo]

Who knows code for a message to the user, when he has to wait a minute while the programme is running? A kind of msgbox without OK or close button, which doesn't stop the program. Thank you in advance for your suggestions.

Rudo

P.S. I know a way round the problem, showing a sheet with the message, but that is not what I am looking for now....

 

[ETID]

Create a user form with a textbox containing your message

then via vb code, set the forms.(visible or show) propertie to true ....when event is done set the same propertie to false.

 

[rudo]

Thank you Etid,

I tried, but doen's work instantly. When using form for the first message, background-color and message do not appear. They do, when I change content.

The code I used:

Userform1.Label1.Caption = "Please wait..."
Userform1.show

Did I forget something? Thanks in advance for your reaction.

Greetings from Holland,

Rudo

 

[BrainB]

I put a text box on to the page then delete it afterwards. Regards
BrianB
** Let us know if you get something that works !
================================

 

[VulcanJedi]

Rudo, again, search the forums first I think this has been illustrated numerous times.
People have developed numerous creative approaches around this dilemna.. Tranpkp
************************************
- Let me know if this helped/worked!