PDA

View Full Version : Processing Time



gscarter
07-24-2008, 05:13 AM
I am running VBA within Excel in Office XP (2002).

The code that i am running takes approximately 15 - 20 seconds to complete.

Does anyone have any suggestion of something i can do/put on screen so the user doesnt think the program has crashed during the time when it is processing.

A animation / image or something like that?

Thanks
Gary

gscarter
07-24-2008, 05:43 AM
Would it be possible for a msgbox to appear saying for example "Processing" with no buttons on it, then it dissappear when processing is complete?

Bob Phillips
07-24-2008, 06:26 AM
Robin Hammond's Progress Bar
http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm

gscarter
07-24-2008, 09:17 AM
Thanks