Is it possible to have a msgbox as an alert in progress without pressing any
key for continue?
Something like to show for a while a message as "workin in progress".

Actually i use an userform and a label ....

Hi Paula,

Perhaps you could use the Excel status bar to display your message:

Application.StatusBar = "Work in progress..."
'Your query code
Application.StatusBar = False

---
Regards,
Norman



"Paula" wrote in message
...
Is it possible to have a msgbox as an alert in progress without pressing
any key for continue?
Something like to show for a while a message as "workin in progress".

Actually i use an userform and a label ....

Take a look at
http://www.xldynamic.com/source/xld.xlFAQ0022.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paula" wrote in message
...
Is it possible to have a msgbox as an alert in progress without pressing
any
key for continue?
Something like to show for a while a message as "workin in progress".

Actually i use an userform and a label ....