My thanks to both of you ... it now works with the following code based on
your valuable directions and input! Brad

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$122" Then
PickSymbolOpen1
End If
End Sub


"Brad" wrote in message
...
Could someone explain the easiest way for me to automatically activate an
existing macro based on clicking on, then selecting a choice from a
dropdown list? Thanks in advance for any advice! Cheers! Brad