PDA

View Full Version : [SOLVED] need help on using results from formula to use in case macro



SteveM99
11-21-2018, 01:23 PM
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
11-23-2018, 01:34 PM
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
11-28-2018, 08:46 AM
Dave,

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

Dave
11-28-2018, 09:46 AM
You are welcome. Thanks for posting your outcomes. Dave