Hi,

Assuming, cells in column A has the validation list, in the worksheet code
module, paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If Target.Value = "a" Then
'call macro a
ElseIf Target.Value = "b" Then
'call macro b
End If
End If
End Sub

This solution has nothing to do with the validation list. Meaning, wether
there's data validation on the cell or not, if you type in "a", the code will
execute.

--
Hope that helps.

Vergel Adriano


"RJB" wrote:

I have a drop-down list (using Data Validation).

Based on which answer is selected from the list, I would like to launch
different macros.

How do I set it up so when you pick "A" from the drop-down it runs Macro_A,
and "B", Macro_B, etc.?

Thanks