Text Box as opposed to HourGlass

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Word OLE to check spelling in text box 1
Excel query not responding 1
Possible to Combine reports to's to a single box? 0
VBA word change keys 0
Import sheets with picture 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Macro to Select text from a point given to a specific word 2

Top