How can I do a progress bar

[bren]

Hi,

I have this macro that gets it´s time to load. I need to create a
progress bar or MsgBox that tells me that the macro is loading. How
can I do this?

Have a nice day

 

[Robert Flanagan]

Loading or running? If running, the simpliest way is to use

Application.Statusbar = "some message"

and change the message at different points in your macro. When all done use

Application.Statusbar = False

to clear the statusbar

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Hi,

I have this macro that gets it´s time to load. I need to create a
progress bar or MsgBox that tells me that the macro is loading. How
can I do this?

Have a nice day

 

[herochenna]

Visit www.ExcelGoodies.Com

 

[Nick Vivian]

Hi,

I have this macro that gets it´s time to load. I need to create a
progress bar or MsgBox that tells me that the macro is loading. How
can I do this?

Have a nice day

have a look at this too:
http://excelexperts.com/VBA-Tips-Update-Statusbar

 

[sami]

Add a progress bar control. Lets say your code performs 10 activities. At the end of each activity, add a one line code to update the progress bar

http://www.ExcelGoodies.Com