Thread: How validation dropdown list open when cell is picked?.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default How validation dropdown list open when cell is picked?.
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

Reply With QuoteReply With Quote