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

--
Message posted from http://www.ExcelForum.com

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 " wrote in
message ...
I've written a macro to run and format reports from large database
files.
This takes some time to run.
I've turned off screen update, and would like a visual indication of
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 the
screen showing what progress has been made.

Cheers
Paul


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/

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)

"Paul_Russell " wrote in
message ...
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


---
Message posted from http://www.ExcelForum.com/