Change text in cell depending which cell user is in

[surkdidat]

I have some text in C5. I want that to change between "HEADLINE A" and "Headline B" depending which cell a user has selected. If a user is in any cell from C7:M59, I want "HEADING A" If a user is in C63:M115 I want it to be "Heading B" (etc)

 

[Kamolga]

I have some text in C5. I want that to change between "HEADLINE A" and "Headline B" depending which cell a user has selected. If a user is in any cell from C7:M59, I want "HEADING A" If a user is in C63:M115 I want it to be "Heading B" (etc)

Right click your sheetname, click view code and paste

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("C7:M59")) Is Nothing Then
    Range("C5") = "HEADLINE A"
End If
If Not Intersect(Target, Range("C63:M115")) Is Nothing Then
    Range("C5") = "HEADLINE B"
End If
End Sub

 

[surkdidat]

Excellent - thank you

Right click your sheetname, click view code and paste

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("C7:M59")) Is Nothing Then
    Range("C5") = "HEADLINE A"
End If
If Not Intersect(Target, Range("C63:M115")) Is Nothing Then
    Range("C5") = "HEADLINE B"
End If
End Sub

 

[Kamolga]

Great! Thanks for the feedback!