More than one action for a command button on userform

A

andrewkard

Active Member

Joined

Apr 6, 2012

Messages

455

• Jun 19, 2012

• #2

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jun 19, 2012

• #3

Maybe like this

Code:

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

 

Upvote 0

Trevor G

Well-known Member

Joined

Jul 17, 2008

Messages

6,746

Office Version

1. 365
2. 2021
3. 2019
4. 2016

Platform

1. Windows

• Jun 19, 2012

• #4

Something like:

Code:

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

 

Last edited: Jun 19, 2012

Upvote 0