Closing UserForms

K

k209310

Active Member
Joined
Aug 12, 2002
Messages
382
I have a button on a form which takes a user to the another form.

How can i get the first form to close when the button is clicked to to open the second?
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
In the Click event procedure for the button on the first form, put:

Me.Close

before showing the next form.
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Userform textbox launches another userform
Replies
8
Views
344
FedElecQaEng
F
P
  • Solved
Userform Cancel Button - Click No
Replies
3
Views
255
dmt32
D
P
  • Question
Send UserForm value to another UserFrom
Replies
5
Views
238
RoryA
RoryA
I
  • Solved
Select Textbox 1 / set focus on userform when another userform closes
Replies
5
Views
234
Legacy 143009
L
O
  • Question
Open Workbook2 from Workbook1 and close workbook1
Replies
6
Views
213
Oseitutuakrasi
O

Forum statistics

Threads
1,214,659
Messages
6,120,786
Members
448,994
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top