VBA help: Running a Macro within a Macro based on a cell value

[willow1985]

I need another Macro to be called based on a cell value in a particular workbook (yes the workbook will be open)

What I need is as follows:

IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8

= “Second”

Call Macro “Second”

IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8

= “Third”

Call Macro “Third”

IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8

= “First” OR BLANK

Call Macro “First”

Below is an idea of how the code runs before I need it to take a break and call another macro to run:

‘Macro code etc etc

Range("Y1").Select

ActiveCell.FormulaR1C1 = "Falls between prev yr selected range"

Range("Y2").Select



‘REQUIRE RUNNING ANOTHER MACRO BASED ON CONDITIONS (AS PER ABOVE)



‘Continue running remaining macro

Sheets("Data").Select

Workbooks.Open etc etc

Any help would be greatly appreciated

Thank you!

 

[JLGWhiz]

With Workbooks("Manager Review Meeting Dashboard").Sheets("Dashboard")
    If .Range("W8") = "" Then
        First
    ElseIf .Range("W8") = "Second" Then
        Second
    ElseIf .Range("W8") = "Third" Then
        Third
    End If
End With

 

[JGordon11]

Something like this maybe. It would probably be safer to name W8 in case you nee to move it or add rows or columns before it. If you name it FST then just change Range("W8") to Range("FST").

Sub CallingMacro()

    MsgBox "Running Calling Macro"
   
    Select Case Workbooks("Manager Review Meeting Dashboard").Sheets("Dashboard").Range("W8").Value
        Case "Second"
            Second
        Case "Third"
            Third
        Case Else
            First
    End Select
    
    MsgBox "Calling Macro Complete"
    
End Sub

Sub First()
    MsgBox "Running First"
End Sub

Sub Second()
    MsgBox "Running Second"
End Sub
Sub Third()
    MsgBox "Running Third"
End Sub

 

[willow1985]

Thank you all very much, I went with JGordon11's solution without the message box. Much appreciated, Thank you all again! ? ?

 

[JLGWhiz]

Thanks for the feedback,
Regards, JLG