Help... Using a user form to show progress inside a loop

I have a very simple userform with only one text field (Name=SpecID) - Inside a loop, I want to use the form to show progress on the form using the text field... I'm using

Please Login or Register  to view this content.

It shows the text in the form OK - but the code stops and waits for me to manually close the from (click X) before the loop continues.

How can I just show the text on the form and keep the code running through the loop to show progress without stopping for a manual close of the form?

Thanks for your help

Removed my answer after refreshing and seeing cytop's note....

( I think I did not say much more anyway... added few links, screenshot and stuff... )

Edit later
and then later.......

Put it back....

_.____________________________________________________________________



I think I had this problem once, I do not quite understand why... something like
' there are two ways ( modes ) of showing a form in vb - modal and modeless. a modal form takes the focus and won't return control to the calling module until it is closed. a modeless form is shown and then control is immediately returned to the calling module. http://vbcity.com/forums/t/53342.aspx

Here you go:
http://stackoverflow.com/questions/1...code-execution
http://vbcity.com/forums/t/53342.aspx
http://gregmaxey.mvps.org/word_tip_p...nced_tips.html


_......_____________________________________--

I think the "Model" thingy is needed to be changed, or else I expect the default is to wait for you to do something in the UserForm before it moves on...

You need this I think:

Please Login or Register  to view this content.

I think this is the same, but I am not quite sure

Please Login or Register  to view this content.

ModelWonks.JPG http://imgur.com/sJI5bDa
ModelWonks.JPG


Alan

Originally Posted by Andrew Entee

...I consider myself admonished and educated regarding code tags.

Hi, Andrew,
So how about Editing your first post and putting the Code Tags in so that I can post my contribution. - I did not have a lot to add, but it could be useful for future reference

Alan

Originally Posted by Andrew Entee

Thanks Alan... Done. I see how that works and helps now.

Thanks, put my thing back in