Chris,

The general technique is to show the form, then initiate your code from
within there, updating the progress bar as you go.

John Walkenbach shows how at

http://j-walk.com/ss/excel/tips/tip34.htm

He also has a more complex status bar progress bar.

http://j-walk.com/ss/excel/files/developer.htm



--

HTH

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

"Chris Gorham" wrote in message
...
Hi,

I'm designing a macro that takes a few seconds to run on
big sheets. I'd like to update the user on progress. I
could do this via the statusbar, but I'd prefer to have a
pop userform confirming the tasks as they complete.

the userform's I've developed before have to be hidden
before the code will run - how do I keep it open while the
code runs in the background..??

thks..Chris