How to run a macro based on values in another sheet’s column?

[Indominus]

Hello. Is there a way to run a macro based on values in a column in another sheet?

I have a certain workbook with many macros and sheets. Then I have a main macro that runs all of these back to back. This is where I want to add this code to. Want I want to do is run macro1 if Column A in Sheet “Times” contains the word “Unknown” and if not run macro2. Thank you to anyone willing to help.

 

[JLGWhiz]

You did not specify how you wanted to initiate the macro so I assumed you would assign it to a Forms Control button. In that case this code needs to be copied to code module1 or any other public code module.

Sub t()
With Sheets("Times")
    If Application.CountIf(.Range("A:A"), "Unknown") > 0 Then
        Macro1
    Else
        Macro2
    End If
End With
End Sub

 

[Indominus]

You did not specify how you wanted to initiate the macro so I assumed you would assign it to a Forms Control button. In that case this code needs to be copied to code module1 or any other public code module.

Sub t()
With Sheets("Times")
    If Application.CountIf(.Range("A:A"), "Unknown") > 0 Then
        Macro1
    Else
        Macro2
    End If
End With
End Sub

This works. Thank you so much. Just added "Call" next to the names as this will be in my longer main code

 

[JLGWhiz]

It should have worked without the 'Call' but it is your option.
Regards, JLG

 

[Indominus]

It should have worked without the 'Call' but it is your option.
Regards, JLG

Oh I didn’t even realize that. Thank you for letting me know.

 

[JLGWhiz]

Read this

Calling Sub and Function procedures (VBA)

Office VBA reference topic

docs.microsoft.com

 

[Indominus]

Read this

Calling Sub and Function procedures (VBA)

Office VBA reference topic

docs.microsoft.com

Will do! Thanks

 

[JLGWhiz]

Will do! Thanks

You're welcome,
regards, JLG