Run Command Button Click From Another Command Button

Re: Activate The Button_click Method Via Variable/string

Perhaps the following (untested) would work
[vba]Run strButname & "_Click"[/vba]

Re: Activate The Button_click Method Via Variable/string

I don't think you can assign a Button directly to a string variable. But why would you?

Anyway a work around would be to have a UserForm with say three buttons and a list box with the following code behind the user form. The list box would be populated with the names identifying which button click code to run when selected.

Note that the button click code must not be “private” if the code is called from outside the userform module. That is if the list box was on another userform.

Sub CommandButton1_Click()
MsgBox "Command Button1 Code Fired"
End Sub


Sub CommandButton2_Click()
MsgBox "Command Button2 Code Fired"
End Sub


 Sub CommandButton3_Click()
MsgBox "Command Button3 Code Fired"
End Sub


Private Sub ListBox1_Click()
    Select Case ListBox1.Value
        Case "Button1": UserForm1.CommandButton1_Click
        Case "Button2": Userform2.CommandButton2_Click
        Case "Button3": userform3.CommandButton3_Click
    End Select


End Sub

Re: Activate The Button_click Method Via Variable/string

Lets see if I understand what you are saying.

The user is presented in some fashion a selection of pseudo buttons. Each pseudo button represents a real button which has a button_click macro attached to it. The user can pick and chose which buttons to be added to a UserForm. After the first pseudo button is chosen a UserForm is created and the associate real button of the chosen first pseudo button is applied to the created UserForm . Then other pseudo buttons can be chosen and the associated real buttons will be added to the created UserForm.

Is this what you are asking how to do?

Re: Activate The Button_click Method Via Variable/string

Does this help?

Private Sub CommandButton1_Click()
    CommandButton2_Click
End Sub


Private Sub CommandButton2_Click()
  MsgBox "I'm CommandButton2 Code"
End Sub

Re: Run Command Button Click From Another Command Button

Something like this maybe.

Userform with 5 buttons. cmdA to cmdE
1 textbox
1 commandbutton

[vba]Private Sub cmdA_Click()
MsgBox "cmdA"
End Sub
Private Sub cmdB_Click()
MsgBox "cmdB"
End Sub
Private Sub cmdC_Click()
MsgBox "cmdC"
End Sub
Private Sub cmdD_Click()
MsgBox "cmdD"
End Sub
Private Sub cmdE_Click()
MsgBox "cmdE"
End Sub
Private Sub CommandButton6_Click()

Dim vntBut As Variant

On Error Resume Next

For Each vntBut In Split(UCase(TextBox1.Text), ",")
Me.Controls("cmd" & vntBut).Value = True
Next

End Sub
[/vba]

In the textbox enter comma delimited list of buttons to PUSH.
For example,

e,a,c

Re: Run Command Button Click From Another Command Button

ExcelJunkie, your post and thread title should always reflect what you are attempting to do, as apposed to what you THINK you need to achieve it. Same logic applies when searching.

VBA for Multiple Command Button

Hi All,

I am trying to write VBA for Command button. Herewith I have updated my queries in details. Please do the needful.

1) I have multiple button in one of the worksheet like attached below. If I click button based on Column 1 value, it need to search data in second worksheet. [TABLE="class: grid, width: 500"]

A

1

Button 1

B

1

Button 2

C

1

Button 3

[/TABLE]

2) Is there any way to create subroutine program while running an another macros.

3) Is there any way to assign VBA code to button as action instead of macros. For example

ActiveSheet.Shapes("Button 1").Select
Selection.OnAction = "=sum(B1:B2)"
Range("L20").Select

Re: Run Command Button Click From Another Command Button

Please start your own thread. Give it a title that accurately and concisely summarises your issue and explain your problem fully.

Also, 1 issue per thread please and that issue is as described in the thread title.