can anyone help me run this code when I press a form button Instead of when there is a change?
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$Q$10" Then Exit Sub
If Range("Q10") < 75 Then
MACRO1
Else
MACRO2
End If
End Sub
thank you & brgs
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$Q$10" Then Exit Sub
If Range("Q10") < 75 Then
MACRO1
Else
MACRO2
End If
End Sub
thank you & brgs