![]() |
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. |
All times are GMT +1. The time now is 01:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com