Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dialog showing time
hi,
I'm trying to show on a message dialogbox with the time is taking for the macro to run. Or some kind of message that will let the user know that the macro still running... Sometimes, the users get crazy and start clicking everything like if the computer is not responding when actually the macro is running. I appreciate your help. -- Thank you... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dialog showing time
Check out this link on progress bars
http://www.andypope.info/vba/pmeter.htm http://www.cpearson.com/Excel/Progress.htm OR use Excel status bar Application.DisplayStatusBar =true Application.Cursor = xlWait Application.StatusBar = "Please wait...<some activity in Progress" Application.ScreenUpdating = False 'your code Application.ScreenUpdating = True Application.Cursor = xldefault Application.StatusBar = False If this post helps click Yes --------------- Jacob Skaria "EXCELMACROS" wrote: hi, I'm trying to show on a message dialogbox with the time is taking for the macro to run. Or some kind of message that will let the user know that the macro still running... Sometimes, the users get crazy and start clicking everything like if the computer is not responding when actually the macro is running. I appreciate your help. -- Thank you... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dialog showing time
Thank you i'm going to use the screen option update.
-- Thank you... "Jacob Skaria" wrote: Check out this link on progress bars http://www.andypope.info/vba/pmeter.htm http://www.cpearson.com/Excel/Progress.htm OR use Excel status bar Application.DisplayStatusBar =true Application.Cursor = xlWait Application.StatusBar = "Please wait...<some activity in Progress" Application.ScreenUpdating = False 'your code Application.ScreenUpdating = True Application.Cursor = xldefault Application.StatusBar = False If this post helps click Yes --------------- Jacob Skaria "EXCELMACROS" wrote: hi, I'm trying to show on a message dialogbox with the time is taking for the macro to run. Or some kind of message that will let the user know that the macro still running... Sometimes, the users get crazy and start clicking everything like if the computer is not responding when actually the macro is running. I appreciate your help. -- Thank you... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time error dialog | Excel Programming | |||
run-time error Dialog | Excel Programming | |||
URGENT: Office Add-Ins not showing in AddProject Dialog! | Excel Programming | |||
Delete worksheet - dialog box showing | Excel Programming | |||
Showing Time | Excel Programming |