On Tue, 02 Aug 2005, STEVE BELL wrote:

Depends on what you mean when you say the cursor is still in the drop-down.
Most of the time I use a predefined list and just select what I want - the
change event fires.

If I am typing something into the drop-down nothing happens until I use the
Tab or Enter Key.
Until then nothing will happen.

Well, there are only two choices on this list. The user would never type
them in. They would drop down the list and select. I'm not sure just what
the status is of the cell when this sub is then run:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
End Sub

Should I be using another type of event? I see on the list a
SelectionChange event. But trying it right now a data validation drop down
doesn't trigger it.

Don <www.donwiss.com (e-mail link at home page bottom).