MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Box/List


Posted by Kerri on February 01, 2002 8:24 AM

How do I input a list into a single cell, then use a Combo Box to select from the list? Please help!


Posted by Russell Hauf on February 01, 2002 8:32 AM

You can't without some code written to parse out the cell. Why can't you put your list into multiple cells?

Posted by Helen on February 01, 2002 10:15 AM

If you want to just be able to select an item from a list you can use Data Validation (file menu data/validation). Select 'list' from the 'allow' box, and then that will bring up another box 'source', and use that to select the list you want to appear in the drop down box. This will then make the drop down box appear in the cell you have selected. Note: I think you need to add the title of the box/cell before you add a list to it as I don't think you can do it after as it says the users restricted the cell or something.

Hope this helps.

Posted by Kerri on February 04, 2002 8:15 AM

Thank you for your response. I used the validation as an alternative option and it worked fine. However, I was trying to duplicate another form that was made by someone else in my company who is no longer here. A simple copy and paste wouln't work. What this person did, was put a list in a single cell, but he didn't use the validation option, because when I looked at that information it wasn't there. However if you right-click and select "pick from list" the list was there. Over the cell he had a combo box, however, the combo box could not be selected or moved. The worksheet is not protected. I'm stumped. What are your thoughts?