VBA run 3 different macros based on 3 different conditions

[willow1985]

Hello,

Is there a VBA code that can select a workbook and run different macros on condition?

For example:

If sheet 1, cell: A15 says the word "Blue"

Go to Sheet 3

run macro for blue

Or If sheet 1, cell 15 says the word "Red"

Go to Sheet 2

run macro for red

Or if Sheet 1, cell A15 says the word "Green"

Go to Sheet 5

run macro for green

Thank you

Carla

 

[Logit]

.
Look at If / ElseIf / Then ... or a SELECT CASE statement.