Closing forms
 

I have hit a block, I need to close one user form and invoke another. The
first user form inputs data into a specified cell when you click on
"Continue" what I need is for that form to close and another form to open
right after it when you click on "continue". can anyone assist?

Closing forms
 

From the first form include the following code attached to the Continue
click event

Private Sub Continue_Click()
Unload Me
UserForm2.Show
End Sub

Cheers
Nigel



"M atthew J. Couture" wrote in message
...
I have hit a block, I need to close one user form and invoke another. The
first user form inputs data into a specified cell when you click on
"Continue" what I need is for that form to close and another form to open
right after it when you click on "continue". can anyone assist?






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---