alert

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 ....
>
>