MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Display message when processing lengthy operations

Posted by Dan Burton on August 02, 2001 10:54 AM

I've some VBA code to cut and paste large quantities of data from one part of a sheet to another - as there is so much data involuved it takes the PC about 10secs to processes - many of the users think the PC has crashed in this time - is there a way Excel can display a message saying "Please Wait" while it is processing? - I'm sure I saw that it could be done somewhere... Any help would be appretiated.

Posted by Ivan F Moala on August 03, 2001 4:11 AM

There are numerous ways of doing this here are