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!
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?
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?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.