Conditional Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Private Sub commandButton1_Click()
if Range("A1").Value = "Apply Manually" then exit sub

' current code

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting macro: simple, but doesn't work 6
Need Macro... 8
Problem in adding macro to ribbon through Add-in 7
I need a macro to run on a set condition 3
How to call Excel add-in macro from a button… 1
running macro from keystrokes versus from ribbon 2
Pasting cell contents into a macro 1
Private Macros 3

Back
Top