Thread
:
UserForm as Progress Indicator
View Single Post
#
3
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
UserForm as Progress Indicator
For a few possibilities, see my post at
http://www.mrexcel.com/board2/viewto...?p=88129#88129
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I am trying to use a UserForm as a progress indicator.
The idea is to create a label within a frame within a
userform and then adjust (in real time) the label's width
as a percent complete indication. This works OK as long
as the code "starts" in the UserForm code area using, say,
UserForm_Activiate. But as soon as I move all the code
outside of the UserForm code area, problems occur.
Loading and displaying the userform is fine. But I can
not get the userform to relinquish "control" after that.
How do I tell the userform to "stay visible" and "let me
update you" now and again.
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta