Adding a variable in VBA code

[ChristineJ]

I'd like some help with using a variable in VBA for the abbreviated sample code below.

First, I have three macros, listed below. All do different things and work fine.
Sub Feedback_P10()
Sub Feedback_P12()
Sub Feedback_P15()

This following macro checks a cell in row P to see if there is a formula and returns "Yes" in column C in the same row if there is one.

Sub Formula_P(rowNum As Integer)

Dim rowNumber As Integer
Dim columnNumber As Integer
rowNumber = rowNum

If Range("P" & rowNumber).HasFormula = True Then
Range("C" & rowNumber).Value = "Yes"
End If
End Sub

The code below first calls Formula_P for cell P10.

Sub RESULTS()
Call Formula_P(10)
Call Feedback_P10 Is there a way to make this "10" a variable?
End Sub

Here is what I would like to happen using a variable in the Feedback macro:
If Call Formula_P(10) is in the RESULTS macro, the Feedback_P10() should also be called.
If Call Formula_P(12) is in the RESULTS macro, the Feedback_P12() should also be called.
If Call Formula_P(15) is in the RESULTS macro, the Feedback_P15() should also be called.

Thanks!

 

[RoryA]

Is there any similarity between the various Feedback routines, so that they could be replaced with one routine with a parameter, like the Formula routine? If not, you'd need to use something like Application.Run

 

[ChristineJ]

Feedback routines are all different, so I'm not able to handle it like the Formula routine.

Application.run?

Thanks.

 

[RoryA]

Yup.

Application.Run "FeedbackP" & variable

Or since you only have three options, you could use a simple If block or a select case statement.

 

[ChristineJ]

There are actually more than three options in the project - I only posted a short sample.

However, your response about an If block made me see an alternative way of dealing with this, and it is working!

Thanks so much for your response - very helpful! CJ