UserForm as Progress Indicator
 

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.

UserForm as Progress Indicator
 

You can do this in Excel 2000 and later. Show the form
modelessly. E.g.,

UserForm1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MWE" wrote in message
...
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.

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.

UserForm as Progress Indicator
 

There's a ready built one on my site he

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"MWE" wrote in message
...
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.

UserForm as Progress Indicator
 

thanks. just what I needed

-----Original Message-----
You can do this in Excel 2000 and later. Show the form
modelessly. E.g.,

UserForm1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MWE" wrote in
message
...
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.


.

UserForm as Progress Indicator
 

thanks for the reply. I looked at your progress bar. It
is quite nice but a little more complicated than I need.

-----Original Message-----
There's a ready built one on my site he

http://www.enhanceddatasystems.com/E...ExcelProgressB
ar.htm

Robin Hammond
www.enhanceddatasystems.com

"MWE" wrote in
message
...
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.


.

UserForm as Progress Indicator
 

thanks for the reply. You certainly have some interesting
stuff on your site. I was able to solve my problem by
just modifying the show statement. When I have a few
minutes, I will certainly poke around your site.

-----Original Message-----
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.

.