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
some;
http://support.microsoft.com/support/kb/articles/Q211/7/36.ASP?LN=EN-US&SD=gn&FR=0&qry=please%20wait&rnk=5&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K

http://www.erlandsendata.no/english/downloads/userforms.htm


HTH

Ivan