Kristen,

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

Is that the exact syntax of your code in your change event (including
"<macro?")? I'm not sure if you can include "<" & "?" in a macro name.

I have a macro called "LoopCells". It looks something like this:



Sub LoopCells()
...
...
...
End Sub



If I were to call it from the change event using your code, it would look
like this:

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

Just replace "<macro?" with the exact name of your macro. If you have
arguments for your macro, you would type a space between the macro name and
the first argument, then arguments would be separated my commas.

HTH,

Conan






"Kristen" wrote in message
...
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