Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.programming
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 =---
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing workbooks w/o closing Excel Barb in MD Excel Discussion (Misc queries) 3 February 15th 10 06:42 PM
Closing Excel Marvin Kornblau Excel Discussion (Misc queries) 1 January 6th 07 09:09 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
Closing the save changes box John Wilson Excel Programming 0 January 9th 04 04:13 PM
Closing Excel in VBA Keith Willshaw Excel Programming 1 August 15th 03 02:17 PM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"