Assign Button to Macro

[Nitha120]

Hi,
How do I assign 2 or more sub routine (Macro) to the button.
I want to have a button for call Summarize to run 2 subroutine rather then have separate Button for each Macro.

Any suggestion is greatly appreciated!

 

[SkipVought]

hi,

Sub Button_Click()
  Macro1
  Macro2
End Sub

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[Nitha120]

Thank you Skip!

 

[Nitha120]

Oh and 1 more thing, How do I update my Summarize sheet automatically once the original has been change.

another word, Say sheet1 are 50 then I copy to my summarize sheet. When the number 50 change to 100 in
sheet1 I want the number in my summarize sheet update to 100 as well.

any suggestion?

 

[SkipVought]

I assume that your macro puts those values on sheet1.

If so,have your macro ALSO put the value in your other sheet.

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]