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...

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...

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...