Text Box as opposed to HourGlass

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

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
 
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.
 
Back
Top