Run Macro after value change from drop down list

[tx12345]

Hi

I have read several related threads but can't find the answer.

I want to trigger a macro when I select a value from a scroll down list in a cell.

Let's say A1 has a validation list of 5 numbers:

1
2
3
4
5

When I select a value from the scroll down list it will not trigger the macro to run. If I double click on the cell *after* I have selected from the drop-down list, and *then* hit enter, the macro will run.

Please Login or Register  to view this content.

But that sort of defeats the point of using the scroll down list.

Any ideas would be appreciated.
Thanks

tx

btw, I have had some trouble with the search function for this board. anybody else having the same trouble?

[davesexcel]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Application.Run "Book1!Macro1"
End If
End Sub

[tx12345]

Looks like the " " marks made the difference. Thanks. Works great!