I have user form problem

L

Legacy 420921

Guest
[FONT=&quot]I put name of them user form name.show will not open the form[/FONT]
[FONT=&quot]ty[/FONT]
[FONT=&quot]Thomas[/FONT]
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Are you trying to use a button on the sheet?

Code:
Sub optionbutton1_click()

userform1.show

End Sub
 
Upvote 0
What is the name of your Userform

If your UserForm is named Alpha

Script should say:

Alpha.Show
 
Last edited:
Upvote 0
Code:
Private Sub SENDSCHEDULE_Click()
SENDSCHEDULE.Show
End Sub
 
Last edited by a moderator:
Upvote 0
You need to change the name of your button.

The Userform name cannot be the same as the Button.
 
Last edited:
Upvote 0
Thank do that tomorrow. I have other problem I put data in comobox on same user form



Thanks

Thoma
 
Last edited by a moderator:
Upvote 0
What data do you want to put into UserForm ComboBox?

And give me ComboBox name
 
Upvote 0
name of combo box is called CMBTEAM i want Tennessee Volunteers in drop down



Thanks You


Thomas
 
Upvote 0
Are you saying when you open UserForm you want one word:

Tennessee Volunteers loaded into the Combobox

And that's all?

It's called a ComboBox not a Drop Down
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

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