dialog showing time

[EXCELMACROS]

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.

 

[Jacob Skaria]

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

 

[EXCELMACROS]

Thank you i'm going to use the screen option update.