Call a macro - Data Validation

[Anthony G.]

Hello to All:

Cell A1 contains a drop-down list using data validation. Is there a way in which a macro can be activated (Macro1) when the user selects anything from the drop-down list?

Thanks,

Anthony

 

[erik.van.geit]

Hi,

yes, you can "watch" cell A1 for changes

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) <> "A1" Then Exit Sub
'here your code
'or call a macro
End Sub

kind regards,
Erik

EDIT:
http://www.cpearson.com/excel/events.htm
TO INSTALL IN SHEET CODE WINDOW:
1. right click the "Name Tab" of sheet you want code to work in
2. Select "View Code" in drop down menu
3. VBE window will open ... paste code in and exit VBE

 

[Anthony G.]

Awesome!!!

Thank you very much.

Anthony