How validation dropdown list open when cell is picked?.

Is there a way to cause a validation dropdown list to open immediately when
the cell is picked, rather than picking the cell and then the down-arrow?

You could use the selection_change event and a SendKeys command, but
that could cause unexpected results, and is usually avoided.

ron wrote:
> Is there a way to cause a validation dropdown list to open immediately when
> the cell is picked, rather than picking the cell and then the down-arrow?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html