Progress Indicator in form

[Paul_Russell]

I've written a macro to run and format reports from large databas
files.
This takes some time to run.
I've turned off screen update, and would like a visual indication o
the progress the macro is making.
I've seen how to enter information about progress in the status bar
but wondered if there was an easy way to put a box in the centre of th
screen showing what progress has been made.

Cheers
Pau

 

[Bob Phillips]

Paul,

John Walkenbach shows how at http://j-walk.com/ss/excel/tips/tip34.htm

--

HTH

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

 

[Paul_Russell]

Thanks for that.
I've only had a brief glimpse but it looks like it's just the thing I
needed.

Cheers very much

Paul

 

[Bob Phillips]

Paul,

It's good, I can vouch for it, having used the technique myself in the past.

The main difficulty is identifying where in the code to call the update
routine, it needs careful forethought.

--

HTH

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