Thread: Closing forms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_8_] Nigel[_8_] is offline
external usenet poster
 
Posts: 172
Default 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 =---