How do I asign a range of cells to a combobox?

[Christoffer_Col]

I want to have a certain range of cells to be asigned to a combobox. How do I do this? I have been suggested to right click on the combobox, chooce format control and then "input range", the problem is that there is no such option for me.

I also want to know how I can make the same range of cells appear in two (or more) different comboboxes without having the choice of one of them affect the other one. For instance if I have 3 cells in my range with A, B and C written in them, I want A, B and C to appear as choices in each combobox. If I then choose B in the first one B should not be selected in the other one. I should be able to select C in the other one if I want to.

I hope you understand. My english is normally not as bad as this thread might indicate

[dominicb]

Good afternoon Christoffer_Col

I have been suggested to right click on the combobox, chooce format control and then "input range", the problem is that there is no such option for me.

If this is the case then you probably used the wrong type of combobox - perhaps one from the Control Toolbox toolbar?

Use the forms toolbar and find the combobox on there, then just follow the instructions you've been given.

To set up two seperate comboboxes, just set up another one - they won't be linked at all.

HTH

DominicB

[Christoffer_Col]

Thank you very much for your answer. I notice a difference between my combobox and the one in the sheet Im looking at (not created by me).

In the combobox I add (forms toolbar) I can only asign cells from 1 columnm, in the one in the sheet there are cells from 2 columns. How can I do that?

See the attached file for an example of what I wanna be able to do.

Another thing, when i right click on that combobox and choose properties there is a row called "Linked cell", when I go to that cell I notice that my choice from the combobox is written in that cell. How do I do this?

[royUK]

That image looks like a combobox from the Controls toolbox which can have multiple columns.

[dominicb]

Hi Christoffer_Col

when i right click on that combobox and choose properties there is a row called "Linked cell", when I go to that cell I notice that my choice from the combobox is written in that cell. How do I do this?

From the format control dialog box, look for the option called cell link in the control tab.

See the attached file for an example of what I wanna be able to do.

As royUk has said, you will need to use the Control Toolbox toolbar to do this - this is more difficult to use than its Forms counterpart. If you want to go down this route, then once set up, change the ColumnCount property to 2, then you can use an extended range of two columns (specified in the ListFillRange property).

HTH

DominicB