validation

[bforster1]

how do I write code to have a macro "fire" when a validated cell i
changed? I have a list of three options in a validated cell and I wan
different macros to "fire" when different options are selected from th
validated cell list.

I am a newbie so as much detail as possible is appreciated.

Thanks

 

[Tom Ogilvy]

right click on the sheet tab and select view code.

Use the Change event (in Excel 2000 and later)

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If target.Count >1 then exit sub
' is it the validated cell
if target.Address = "$B$9" then
Select Case Lcase(Target.Value)
Case "value1"
Macro1
Case "value2"
Macro2
Case "value3"
Macro3
End Select
End If
End Sub

See Chip Pearson's site for information on events
http://www.cpearson.com/excel/events.htm