Excel macro activation.
Use the Change event of the worksheet, like this:
Private Sub Worksheet_Change(ByVal Target As Range)
'is changed cell in a certain region?
If Union(Range("A1:G10"), Target).Address _
= "$A$1:$G$10" Then
If Target.Cells(1).Value = "B" Then
MsgBox "Cell changed to B"
'other stuff here!
End If
End If
End Sub
Add the above code to the worksheet module.
Cheers,
Dave.
-----Original Message-----
Here is my problem.
I have a dropdown list in multiple cells that I've
created using data
validation feature. For example, my list contains 3
items: A,B,and C.
I also have a macro that I want to run but ONLY if the
user chooses
item B from the list. If he/she chooses either items A or
C, I don't
want the macro to run. Since my list contains words, I
don't know if
there's a way of triggering a macro with a keyword as
opposed to
attaching it to some sort of a button.
There are many rows that use this dropdown list and I was
trying to
see if there's a way of doing that without having to
create buttons.
I greatly appreciate any suggestions. Thanks.
Kate.
.
|