Selection_Change question

[MOB]

I'm using this;

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("C3").Value = 28 Then
        Columns("AK:AM").EntireColumn.Hidden = True
    Else
   If Range("C3").Value = 29 Then
        Columns("AL:AM").EntireColumn.Hidden = True
    Else
   If Range("C3").Value = 30 Then
        Columns("AM").EntireColumn.Hidden = True
   Else
        Columns("AK:AM").EntireColumn.Hidden = False
    End If
     End If
      End If
End Sub

Feel free to improve it lol..............

Anyway, my question is this - cell C3 contains a number (28-31) and the code hides columns based on this value.

However C3 is a formula driven by a data validation cell in cell C2 - so if the user changes the value in C2, the columns will not hide until you click on C3

Is there a simple fix for this?

 

[MOB]

I've had a try but it wont quite work - here are my 2 bits of code, how should I combine them?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("D")) Is Nothing Then _
    MsgBox ("IMPORTANT - Please check funding splits agree before saving!")
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
 
    If Target.Address <> "$C$2" Then Exit Sub
    
    Select Case Range("C3").Value
        Case 28
            Columns("AK:AM").Hidden = True
    
        Case 29
            Columns("AM").Hidden = True
    
        Case 30
            Columns("AK:AM").Hidden = False
    End Select
End Sub

 

[lenze]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column =4 Then
    MsgBox ("IMPORTANT - Please check funding splits agree before saving!")
End IF

If Target.Address <> "$C$2" Then Exit Sub
    Select Case Target
        Case 28 : Columns("AK:AM").EntireColumn.Hidden = True
        Case 29 : Columns("AL:AM").EntireColumn.Hidden = True
        Case 30 : Columns("AM").EntireColumn.Hidden = True
        Case Else : Columns("AK:AM").EntireColumn.Hidden = False         
    End Select
End Sub

lenze

 

[MOB]

Thanks to you both - I now have it working perfectly!