If you are using Excel 97 data validation change does not fire an event.

If that's what you're using requires radical workaround. Maybe simulate with
a Combobox from the Controls Toolbox and link your code into that. Or link
the changing value to a formula and look at the Calculation event. Update
and compare a module level variable, or static variable within the event
code, to the changing value.

Regards,
Peter T

Regards,
Peter T
"choice" wrote in message
...
i have a data validation with a drop down list, and

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("d2").Address Then
Range("d5").Value = Range("b1").Value
Range("f5").Value = Range("c1").Value
Application.Run "changesquare"
End If
End Sub

however when i drop down the list and select a different value nothing
happens
any ideas?

thanks in advance