How to run a macro in a different macro?

[smerrick]

Hello,

Thanks for reading.

I can record simple macros using shapes. For example, I will paste in a shape, assign macro and then record away. However, there are instances whereby I have created more than 1 separate macros but I cannot seem to link them into one main macro.

As a simple demo, I have 2 separate macros, shown below. My question is, how can I modify Sub Oval4_Click() so that once it has performed its own macro that straight after it it will also work on Sub Oval5_Click()? At the moment I use 2 shapes but want to cut this down to just one.


Sub Oval4_Click()
'
' Oval4_Click Macro
'
Range("G40").Select
ActiveCell.FormulaR1C1 = "1"
Range("G41").Select
End Sub

Sub Oval5_Click()
'
' Oval5_Click Macro'
Range("G46").Select
ActiveCell.FormulaR1C1 = "2"
Range("G47").Select
End Sub

 

[Fluff]

Are both macros working on the same sheet?

 

[smerrick]

Are both macros working on the same sheet?

Hello, Yes the macros are in the same sheet. I think I have found the solution mind, all I needed to do was to add the line:

Run "Macro name"

And this has done the trick. Appreciate you reading my post - thank you.

 

[Fluff]

Glad you were able to sort it & thanks for the feedback

 

[LlebKcir]

you almost have it smerrick

call Oval4_Click

will run Oval4 macro for you.

 

[crystalneedshelpplzthnx]

This is also an option...

Application.Run "Macro Name"

 

[LlebKcir]

This is also an option...

Application.Run "Macro Name"

crystalneed... Thank you, that is new to me. Is there an advantage to Applicaiton.Run over call?

 

[crystalneedshelpplzthnx]

crystalneed... Thank you, that is new to me. Is there an advantage to Applicaiton.Run over call?

You are quite welcome. I get so much assistance from the community, I like to contribute whenever possible.
But I don't think there are any additional advantages of one over the other. I just threw it in as an option.

Happy Rubber Ducking
Crystal