Conditional Macro
Private Sub commandButton1_Click()
if Range("A1").Value = "Apply Manually" then exit sub
' current code
End Sub
--
Regards,
Tom Ogilvy
"Kav" wrote:
I have a macro which is assigned to a control box or button. However I do not
want the macro to run if a value is entered in another cell in the worksheet.
Eg
if Cell A1 has a drop down list and if "Apply Mannually" is chosen then the
macro should not run if teh user accidentally presses the control box button
How can I do this
--
Kav
|