Combo Box Drop Down/Editable

[darthsaki]

Hello,

I'm trying to create a drop down box which both displays a range of values to choose from at the click of an arrow, and allows a user to input their own cell value (which may or may not match one of the values in the range). I think I need to use a combo box to accomplish this, but I'm very new to excel and I get confused trying to implement them. I'm using Office 2007. Any help will be much appreciated.

Thanks.

[Richard Buttrey]

Hi,

Yes a ComboBox will allow you to list a range of values, or allow the user to enter their own value. I presume when you referred to the user inputting a cell value that was a typo. The user can input whatever they want, but if they input a cell reference, the combobox won't know it's a cell reference unless you write some code to deduce this.

It differs to a ListBox since a listbox only allows a predefined list of values.

The easiest way (I find), to populate either box is to use name a range of cell on a sheet and enter the name in the RowSource property of the box. It's easier than using the .AddItem instruction. You can also use the ControlSource property which accepts a cell reference, which will be updated from the List/Control box input. And vice-versa, if the cell value is changed this will update the List/Control box.

HTH