need help on using results from formula to use in case macro

[SteveM99]

I am trying to use the results of a formula in my case macro but cannot figure out code.

formula in cell c3 is an index match formula

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("C3")) Is Nothing Then
Dim x As String
x = Range("c3").Text
    Select Case x
      Case "JAY": FF199_ONLY_JAY
End Select
    End If
 
    End Sub

[Dave]

What's the code supposed to do? If you have "JAY" in C3 then FF_ONLY_JAY ??????? That doesn't do anything???? A bit more info about your desired outcome is needed. Dave

[SteveM99]

Dave,

Thank you for responding for more clarity. I revised my approach and I achieved what I needed.

[Dave]

You are welcome. Thanks for posting your outcomes. Dave