I have a column (D) of cells that the end user will select from a drop down
validation list. I would like when this drop down is changed, that the
change will prompt the macro. I have tested the rest of the macro and it
works but I can't get the change event to work. The code I have for the
change event is:

If Target.Column = 4 And Target.Row < 500 Then
<macro?
End If

I am fairly new to VBA and am very excited that I was able to write the
other parts of the program and get them to work. I'm finding the book I
bought leaves alot to be desired and if the example is not exactly what you
need, the explanation for how the example works is not there. I would really
appreciate anyone's help.
--
Thanks - K