Don,

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.

In fact when you are working in a cell (any cell) all kinds of actions are
put on hold until the Tab key, Enter key, (arrow key*), are clicked. *
Only works for numeric entries.

In summary - the entry must be complete.

Many a time I leave the cursor active in a cell and go crazy until I realize
that the interior of a cell is still active...

And than I am using Excel 2k...

--
steveB

Remove "AYN" from email to respond
"Don Wiss" wrote in message
...
On Tue, 02 Aug 2005, STEVE BELL wrote:

I am always going back and forth with the macros in break mode or when
stepping through code (with F8).

Of course.

The only time when I have problems is when a cell is in the middle of
being
edited (the cursor is
still somewhere in a cell).

That may be it! Remember I wrote this was a data validation drop down
list.
So the cursor is still in the drop down when it fires off the change
event.

I am using xl2002.

So one solution would be to change to a real combo box. Or is there a way
to do the change after the data validation has finished?

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