Combo Box

[tigrouh]

Hello, I want to use a combo box for selecting from entries in columns on a seperate sheet. In the properties window for the combo box how do I tell it which LinkedCell and ListFillRange ranges to use? Thanks for any help!

 

[Andrew Poulsom]

Like this:

Sheet2!A1:A3

 

[tigrouh]

Combo box

Thanks but I still can't get the box to populate with my list, I should say that the combo box is embedded into a worksheet. What am I doing wrong please?

 

[Andrew Poulsom]

Re: Combo box

Thanks but I still can't get the box to populate with my list, I should say that the combo box is embedded into a worksheet. What am I doing wrong please?

I don't know what you are doing wrong. What do you have for the ListFillRange?

 

[Datsmart]

If you are using a Controls Toolbar ComboBox:
Assign your ComboBox list like this:
Turn on Design Mode using the Controls Toolbar Design Mode icon.
Select the ComboBox
Click the Properties icon
For "ListFillRange" type either the Named Range of your list or the range address.

If you are using a Forms ComboBox:
Assign your ComboBox list like this:
Right click the comboBox
Choose "Format Control"
A Dialog box will open
Click the "Control" tab
Type the Named Range of your list
- or -
Click the range selection icon to manually select your range.