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