Macro to Click Button?

[Chronichalt]

I can't figure out how to reference macro subs to macro subs (If
Possible???). I want to write a macro to an object that if selected,
also runs the attached macro to a seperate object. My goal in this is
to limit the amount of code in my spreadsheet by referencing code
already written. I may be going about this all wrong, please give me
some sugestions.

What I need is a macro that will click button A if I click button B...

 

[Die_Another_Day]

Like...
Sub MacroA()
'Your Code
Call MacroB
End Sub
?

HTH

Die_Another_Day

 

[Chronichalt]

Tight! Perfect.

Like...
Sub MacroA()
'Your Code
Call MacroB
End Sub
?

HTH

Die_Another_Day

 

[Ingolf]

Hi,

provided you have a UserForm1 with ButtonA and ButtonB on it. Now you
want to trigger the click-event of ButtonB when actually clicking on
ButtonA. Try the following

Private Sub ButtonA_Click()
'Your code for this event
UserForm1.ButtonB.Value = True
End Sub

Regards,
Ingolf

 

[Ardus Petus]

Private Sub ButtonA_Click()
'Your code for this event
ButtonB_Click
End Sub

HTH