Close userform with a button.

Dinictus

Board Regular
Joined
Mar 19, 2002
Messages
162
probably a simple one but I can`t find the right sytax for this. I want a button on my userform to close it.

What is the syntax for this?


Private Sub CommandButton3_Click()

UserForm1.Close, exit? HOW?

End Sub

Thanks people.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Thanks Tom.

Is there any way of findings these things out without having to go on a course or something like that?

I try to find out simple things like this myself first before asking them here but
I could not find this in any help file.
 
Upvote 0
The absolute best way to learn is in VB help
The first thing new programmers need to learn is how to use the helps provided.

Books are great!

When you are stuck this board is great!

Have fun programming!!!

If you have trouble, come here or you can keep my E-mail
I'll help you if I can

tstom@hotmail.com
 
Upvote 0
I really can`t believe how helpfull people on this forum are. Yesterday audiojoe just mailed me a piece of programme in an instant and you are also real helpful.

*APPRECIATION*

And I`ll do my best to follow this behaviour.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

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