yes there is. when after you have entered all your program events of
the cmdSubmit (command button) just add this line at the very end.

Call UserForm_Initialize

This will make it "re-initialize" the form after the other functions
have taken place. I am still learning forms too though, so if anyone
knows fo a better way to do this, please don't hesitate to post it!

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=388184