Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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?

Re: Advanced Combo Box

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.