More than one action for a command button on userform

[bt2086]

How do I assign 2 different role to one command button. For example, I'd like the "save" button on the userform to save the value from the textbox into a worksheet as well as open a different userform.

 

[andrewkard]

Why don't you want to create two buttons? Maybe check box can help you in "assign 2 different role to one command button"?

 

[VoG]

Maybe like this

Private Sub CommandButton1_Click()
Sheets("Sheet1").Range("A1").Value = Me.TextBox1.Value
UserForm2.Show
End Sub

 

[Trevor G]

Something like:

Sheets("SheetName").Range("The Cell ID").Value = txtBoxName.Value
Me.Hide
FrmUserform.Show