How do I continue a routine while showing a userform?
 

I have a userform that displays information regarding what is happening
behind the scenes; however, when I display the userform it stops the program
looking for a response. I could use a "Call XXX" where xxx is the name of
the routine I want to start with, but since my userform is called up in the
middle of a bunch of if..then statements I just wanted to see if there is a
basic line of code that will let my code continue to update in the background
while the userform is continually being updated.

The basics of my updated userform came from the knowledgebase in Article ID
: 258511. http://support.microsoft.com/kb/258511/en-us

The main issue I am having with the article is it wants me to use the Call
Main - where I don't want to do it that way if I don't have to ...

Thank you --

Jim

How do I continue a routine while showing a userform?
 

I found an answer searching through this forum saying to use vbmodeless in
the following string by Tom Ogilvy ...

http://www.microsoft.com/office/comm...xp=&sloc=en-us

Thank you ...

"Rubble" wrote:

I have a userform that displays information regarding what is happening
behind the scenes; however, when I display the userform it stops the program
looking for a response. I could use a "Call XXX" where xxx is the name of
the routine I want to start with, but since my userform is called up in the
middle of a bunch of if..then statements I just wanted to see if there is a
basic line of code that will let my code continue to update in the background
while the userform is continually being updated.

The basics of my updated userform came from the knowledgebase in Article ID
: 258511. http://support.microsoft.com/kb/258511/en-us

The main issue I am having with the article is it wants me to use the Call
Main - where I don't want to do it that way if I don't have to ...

Thank you --

Jim