PDA

View Full Version : Showing a userform, but not stopping code



mctabish
07-14-2009, 07:46 PM
I want to use a userfor for something like
"Now working on Item:xxxxxx"
(and a LOT more items.)

How would I do that. I want the info to be displayed while the rest of the code is processing, and changing when a new record is is being worked on...

Thanks

JimmyTheHand
07-14-2009, 10:31 PM
Set the forms ShowModal property to False.

mdmackillop
07-14-2009, 11:53 PM
You could add a label to the userform and change the label caption to show the information.

mctabish
07-28-2009, 10:15 AM
Thanks! The showmodal is what I needed. Now if I can figure out how to be able to use other workbooks whine this wb is busy in a do while loop.... Hmmmm

Thanks!