Displaying progress on UserForm
 

Problem

I wish to use an UserForm to input parameters to a macro
and then also as a means of showing the macro is in
progress by means of the extending blue bar (or similar)

To transfer the parameter settings to the macro I have to
come out of the form by unloading or hiding it. If I then
re-enter the form (load or show) how do I automatically
trigger the timer event to generate the extending blue bar.

The answer is probably very simple, but then I am no
expert. Any help gratefully received.

Displaying progress on UserForm
 

This link may give you some help:

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

HTH


--
Michael J. Malinsky


"Nigel Stevens" wrote in message
...
Problem

I wish to use an UserForm to input parameters to a macro
and then also as a means of showing the macro is in
progress by means of the extending blue bar (or similar)

To transfer the parameter settings to the macro I have to
come out of the form by unloading or hiding it. If I then
re-enter the form (load or show) how do I automatically
trigger the timer event to generate the extending blue bar.

The answer is probably very simple, but then I am no
expert. Any help gratefully received.