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.