ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Displaying progress on UserForm (https://www.excelbanter.com/excel-programming/271159-displaying-progress-userform.html)

Nigel Stevens

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.


Michael J. Malinsky

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.





All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com