MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pick From List in VBA

Posted by Jim N on June 02, 2001 8:16 PM

I have a quick question for you. Pressing Alt (Arrow Down) causes a
Pick From List box to appear. You can right click on a cell and choose
'pick from list', to generate the dropdown also. Is there any code in VBA
that would allow a double click on a cell to produce the drop down box? I
know how to use on Double Click, but I can't find the code that calls the
drop down box. Thanks for your help.

Posted by AB on June 05, 2001 12:42 PM

Application.SendKeys Keys:="%{DOWN}"

Perhaps crude but effective:
Application.SendKeys Keys:="%{DOWN}"

The Excel Logic Page