How do I...

[Guest]

...tell Excel to run a macro based on information entered into a specific cell? Eg if user enters N run the macro, if they enter Y do nothing.

Thanks in advance!

 

[Mark O'Brien]

I'm assuming that the value Y/N value will go in cell "A1".

Right click on the sheet tab and select "View Code".

Insert this code:

<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And UCase(Target.Value) = "N" Then
MsgBox "Hi"
End If
End Sub</pre>

Change the 'Target.Address = "$A$1"' to whatever cell you need it to be.
Change the 'msgbox "hi"' line to the name of the macro you want to run.

HTH

 

[Guest]

Thanks very much, this works fine! Now it does what I want is there a way to get the cell selector to move two cells to the right after the macro has run? For example, I put an N in A1, the macro runs, then I want the cell selector to move to cell C1.

 

[JohnJay]

ActiveCell.Offset(rowOffset:=0, columnOffset:=2).Select