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.

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.

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.

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.

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.


.

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.


.

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.

.