Text Box as opposed to HourGlass
 

I have a macro that imports data from another application. I would like to
display the message "Please Wait While Excel Imports Data" instead of just
displaying the hourglass. Is this possible and if so how?
Thanks in advance.
CB

Text Box as opposed to HourGlass
 

You could use:

application.statusbar = "Please wait..."
'do the work
'reset the statusbar
application.statusbar = false

You could do everything behind a userform and show what you want when you want.

You could show a hidden worksheet, do the work and hide the sheet.



CB wrote:

I have a macro that imports data from another application. I would like to
display the message "Please Wait While Excel Imports Data" instead of just
displaying the hourglass. Is this possible and if so how?
Thanks in advance.
CB

--

Dave Peterson

Text Box as opposed to HourGlass
 

Dave,
Thanks. This is exactly what I needed.
Cheers,
CB

"Dave Peterson" wrote:

You could use:

application.statusbar = "Please wait..."
'do the work
'reset the statusbar
application.statusbar = false

You could do everything behind a userform and show what you want when you want.

You could show a hidden worksheet, do the work and hide the sheet.



CB wrote:

I have a macro that imports data from another application. I would like to
display the message "Please Wait While Excel Imports Data" instead of just
displaying the hourglass. Is this possible and if so how?
Thanks in advance.
CB

--

Dave Peterson