If you have some Excel VBA code which is going to take a little time to run it would be good to display a progress bar to show status of processing - you know, the ones you see during software installations.

Can anyone point me towards some information about this? It would need to be controlled from the VBA because that is where the information is held about the state of the subroutine.

Thanks.

see:http://www.cpearson.com/excel/Progress.htm

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Andy wrote :

If you have some Excel VBA code which is going to take a little time
to run it would be good to display a progress bar to show status of
processing - you know, the ones you see during software installations.

Can anyone point me towards some information about this? It would
need to be controlled from the VBA because that is where the
information is held about the state of the subroutine.

Thanks.

Andy,

Take a look at this one

http://www.enhanceddatasystems.com/E...rogressBar.htm



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andy" wrote in message
...
If you have some Excel VBA code which is going to take a little time to
run it would be good to display a progress bar to show status of
processing - you know, the ones you see during software installations.

Can anyone point me towards some information about this? It would need to
be controlled from the VBA because that is where the information is held
about the state of the subroutine.

Thanks.

I have a couple of examples on my website. One for the statusbar area, one
as a command bar control.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Andy" wrote in message
...
If you have some Excel VBA code which is going to take a little time to
run it would be good to display a progress bar to show status of
processing - you know, the ones you see during software installations.

Can anyone point me towards some information about this? It would need to
be controlled from the VBA because that is where the information is held
about the state of the subroutine.

Thanks.