Pick From List in VBA
Posted by Jim N on June 02, 2001 8:16 PM
Hello,
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.