Userform stops macro - how to continue w/it still visible?

[ScottNiag]

This MUST be simple. I am using a userform with 2 labels on top of each other to act as a progress indicator. I want to load it and leav it loaded while other macros do stuff. Every once in a while, I want to change the .left and .width of the 2 labels to reflect the progress. Everything is fine except - the minute the userform loads, everything stops. There must be some setting or other which can do this. Thks

 

[phantom1975]

It would help if you post the revelant portion of your code.

 

[ScottNiag]

Well, the code is pretty well irrelevant. All I want to do is display a userform and then have the macro that called it continue on its way without
1) Unloading the Userform, or
2) stopping and requiring the user to do anything to the Userform before continuing

 

[ScottNiag]

Now that I think of it, the question is also applicable to msgboxes. How can I get a msgbox to appear and stay there, without requiring the user to click anything, while still continuing on with the macro.

I have a macro doing thousands of loops, and I want to show the pregress to the user. I already display progress on the statusbar, but I was hoping to upgrade it to something moire visually appealing.

 

[bobm]

Have you tried showing the userform as Modeless?

Bob

 

[phantom1975]

The issue is with the Modal setting of these objects. I use XL97 which doesn't allow you to alter these settings. Check the help file you have for your version of Excel for MODAL and see what you come up with. I'm afraid that I don't know much about this property.

 

[Jak]

Hi ScottNiag

I can't help with the Msg Box but here is a link to Erlandsen's VBA site. It has a good example of a single or double progress bar that you can attach your macros to. It might help with your problem.

http://edc.bizhosting.com/english/

 

[bobm]

Scott,

See if this works to allow your form to remain on the screen while your code runs.

frmTest.Show vbModeless

The MsgBox is modal by design and will interupt execution until the user reacts to it.

Bob

 

[stevebausch]

Now that I think of it, the question is also applicable to msgboxes. How can I get a msgbox to appear and stay there, without requiring the user to click anything, while still continuing on with the macro.

quote]

Microsoft has decided to deal with your concern, and millions of similiar concerns, by eliminating MsgBox in VB .Net.


And the answer is....... Use a form.

 

[ScottNiag]

Thx all. Bobm, I got it to stay up , thx.