Excel Friends,
I set up C4:C12 to have some values that are added up at C13. I named C4:C12 as SelectedValues, and I named G3 as TotalValue and made it equal to C13. The following worksheet event does not work.
Can somebody tell me how to fix it? Just one requirement, the ranges need to be named ranges, not hard coded cells references.
Thanks!
I set up C4:C12 to have some values that are added up at C13. I named C4:C12 as SelectedValues, and I named G3 as TotalValue and made it equal to C13. The following worksheet event does not work.
Can somebody tell me how to fix it? Just one requirement, the ranges need to be named ranges, not hard coded cells references.
Thanks!
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Debug.Print [SelectedValues].Address
Select Case Target.Address
Case [SelectedValues].Address
If [TotalValue] >= 100 Then
MsgBox "T Value >= 100"
Else
MsgBox "T Value < 100"
End If
End Select
End Sub