MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Advanced Combo Box


Posted by Trent on June 21, 2001 3:17 AM

I have a 'inherited' an excel spreadsheet that I have been asked to change. One of the items that I have to change is a cell that, when it get the focus, a combo box type button appears on its right and it then is just like a combo box. It is not an embedded combo box and there are no module or any VB code. How do you change the values of the list?


Posted by Ben O. on June 21, 2001 6:03 AM

The cell probably has data validation applied to it. Select the cell and then Validation from the Data menu. If data validation is the culprit, under "Allow" it will say "List." If that's the case, you can change the items in the list by changing the cells that are serving as the list's source.

-Ben O.