Hi Nick,


You cannot show a MsgBox as that will halt code. You can


I know - thats my problem ;o) I thought about something
like a text box which dows not interrupt the macro... the
problem is that these Text boxes are not named fixedly but
e.g. "Text Box 14" so that I can't automatically delete
them after the calculation...

however give the
user some indications:

With Application
.StatusBar = "Hang on. Processing..."
.Cursor = xlWait

Thats quite helpful, thanks; nevertheless more would be
better...

Best

Markus



'Process code

.StatusBar = ""
.Cursor = xlDefault
End With

NickHK

"Markus Scheible"
wrote in message
...
Hi newsgroup,

when I start one of my complex macros, it takes around
half a minute until it ends... is there a possibility to
show the user some messages like "I'm currently
calculating, please wait a moment..."? - otherwise some
people would blindly start clicking something...

Thanks for all ideas!

Best

Markus


.