I have user form problem

[Legacy 420921]

[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]

 

[MFish]

Are you trying to use a button on the sheet?

Sub optionbutton1_click()

userform1.show

End Sub

 

[Legacy 420921]

I am using a command button I did still not working


https://1drv.ms/x/s!AnJwxxiz0Ezpg8dgc7RZ1C_zzZuttg?e=g8y3df


Thanks


Thomas

 

[My Aswer Is This]

What is the name of your Userform

If your UserForm is named Alpha

Script should say:

Alpha.Show

 

[Legacy 420921]

Private Sub SENDSCHEDULE_Click()
SENDSCHEDULE.Show
End Sub

 

[My Aswer Is This]

You need to change the name of your button.

The Userform name cannot be the same as the Button.

 

[Legacy 420921]

Thank do that tomorrow. I have other problem I put data in comobox on same user form



Thanks

Thoma

 

[My Aswer Is This]

What data do you want to put into UserForm ComboBox?

And give me ComboBox name

 

[Legacy 420921]

name of combo box is called CMBTEAM i want Tennessee Volunteers in drop down



Thanks You


Thomas

 

[My Aswer Is This]

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​