How do I add a combo box to a cell?

Tipeshesre · 01-20-2006, 05:10 AM

(a MS Excel quesion)

**Glaswegian** · 01-20-2006, 06:24 AM

Hi

Right click on the space beside your toolbars and select 'Control Toolbox' from the list of toolbars. When this toolbar appears, select the ComboBox icon, click on it and then draw the combobox anywhere on your spreadsheet. Click the Design Mode icon (the blue triangle) to exit design mode.

Does this help?

MoralTerror · 01-20-2006, 06:36 AM

Hi

Click View > toolbars > forms then click the combo box icon

.

On your worksheet click and drag the combo box to the size you need

**ReeKorl** · 01-20-2006, 06:49 AM

Alternatively, put a list of items you want populated in your combo box into some cells in a separate area of the spreadsheet, then click on the cell you want a combo box in and use the Data -> Validation tool on the cell you want a combo box in.

Select List from the menu and then in Source, select the cells you have the list of items in. Click OK and now whenever you click on the cell you applied the validation to, it will come up with the down arrow to the right which allows you to select the item from the list you already set up.

-EDIT

If you don't want the list of items on your spreadsheet anywhere, you can simply put the list in the Source section of the validation tool and separate every item you want in there with a comma.

01-20-2006, 05:10 AM	#1 (permalink)
Tipeshesre Registered User Join Date: Dec 2005 Posts: 10 OS: win xp	How do I add a combo box to a cell? (a MS Excel quesion)

01-20-2006, 06:24 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,393 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Hi Right click on the space beside your toolbars and select 'Control Toolbox' from the list of toolbars. When this toolbar appears, select the ComboBox icon, click on it and then draw the combobox anywhere on your spreadsheet. Click the Design Mode icon (the blue triangle) to exit design mode. Does this help? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-20-2006, 06:49 AM	#4 (permalink)
ReeKorl Superhuman Computer Join Date: Mar 2005 Location: 6th Circle, The City of Dis, Hell Posts: 1,610 OS: WinXP Pro SP2 My System	Alternatively, put a list of items you want populated in your combo box into some cells in a separate area of the spreadsheet, then click on the cell you want a combo box in and use the Data -> Validation tool on the cell you want a combo box in. Select List from the menu and then in Source, select the cells you have the list of items in. Click OK and now whenever you click on the cell you applied the validation to, it will come up with the down arrow to the right which allows you to select the item from the list you already set up. -EDIT If you don't want the list of items on your spreadsheet anywhere, you can simply put the list in the Source section of the validation tool and separate every item you want in there with a comma. __________________ "Sorry, the number you have dialled is imaginary. Please rotate dial by 90 degrees and try again."

01-20-2006, 06:36 AM	#3 (permalink)
MoralTerror Analyst, Security Team Join Date: Nov 2005 Location: UK Posts: 1,968 OS: xp	Hi Click View > toolbars > forms then click the combo box icon . On your worksheet click and drag the combo box to the size you need