Forum Discussion
Sanders_Robert
Nov 09, 2022Copper Contributor
How to activate a macro by a word in a specific cell
1st time user of macro!
NikolinoDE
Nov 09, 2022Platinum Contributor
So I don't know any way right away how you could do this, I'm not sure if this is possible at all.
But here is a link with a code for Run Macro Based On Cell Value maybe it will help you further in your project.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Cells.Count > 1 Then Exit Sub
If IsNumeric(Target) And Target.Address = "$A$1" Then
Select Case Target.Value
Case 10 To 50: Macro1
Case Is > 50: Macro2
End Select
End If
End Sub
Hope I could help you with these information / links.
I know I don't know anything (Socrates)