Macro to Click Button?
 

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...

Macro to Click Button?
 

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

HTH

Die_Another_Day
wrote:
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...

Macro to Click Button?
 

Tight! Perfect.


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

HTH

Die_Another_Day
wrote:
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...

Macro to Click Button?
 

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

schrieb:

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...

Macro to Click Button?
 

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

HTH
--
AP


a écrit dans le message de news:
...
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...