Chris,

You can put the code from your macro into a userform.

Private Sub UserForm_Activate()

TextBox1.Text = "Hello"

'do something

End Sub




Mike Tomasura
"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