Nov 09 2022 06:45 AM
Nov 09 2022 06:55 AM
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)