MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is there another way other than Data Validation?

Posted by Montgomery on July 04, 2001 10:49 AM

Can anyone help me with code that will put a drop down arrow in a cell so that when i click on it i can see a two column list that was created on a spreadsheet. Data validation and vlookup cannot work. I have painfully written some code but i have to select the cell i want and run my macro to select from the list.



Posted by Ivan F Moala on July 04, 2001 11:36 PM

Try using the combobox avail from the controls
toolbox = ActiveX control
Set ColumnCount to 2
Set ListFillRange to your range

Is this what you ae after ??