This is my code: I would like to put a code somewhere in the macro which basically does this,
if Sheet2 A1 = Blue, then run the first part of the macro, if Sheet2 A1 = Red, then run the second part of the macro.
How would I do this?
![]()
Sub Other() ' ' Other Macro ' ' ActiveSheet.Shapes.Range(Array("Check Box 8")).Select Selection.Characters.Text = "Blue" Range("C1").Select ActiveSheet.Shapes.Range(Array("Check Box 8")).Select Selection.Characters.Text = "Red" Range("C1").Select End Sub
Bookmarks