worksheet change and cases

[Mike R.]

Hello,
I am trying to use the worksheet_change with cases, but seem to be having
problems. I would like for various cases to run when the data in B8 changes.
I have 10 difference cases. Any help would be appreciated. Thank you in
advance.
Mike

 

[Frank Kabel]

Hi
you may post your current code as describe what exact probelms you have

 

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)

With Target
If .Address = "$B$8" Then
Select Case .Value
Case "value 1": 'action 1
Case "value 2": 'action 2
'etc.
End Select
End If
End With

End Sub