View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ingolf Ingolf is offline
external usenet poster
 
Posts: 32
Default 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...