Combo Box

jimmywanna · Jan 14th, 2002, 02:14 PM

I've done this recently.
What i did was made a combobox from the "forms" toolbar. Then in the range prompt selected the range of options from the workbook. Then in another cell You make the "link". In the cell you want the selected option to appear type"Index=(First cell in range:last cell in range, link" it works a treat.

Ian · Apr 14th, 2002, 04:37 AM

Help !
I want to add a drop down combo box to cell. The drop down list will be linked to a range in the same workbook.

I managed to do this but it was 3 years ago & I have forgot !

Any help are can anyone recommend and good book ?

thanks

Ian

Bolton
UK

Aladin Akyurek · Apr 14th, 2002, 04:45 AM

See whether

http://www.mrexcel.com/board/viewtop...5037&forum=2&2

helps.

gareth · Apr 26th, 2002, 02:38 AM

Dropdown boxes =

Make a range which you want to copy into dropdown

goto>>Insert>>name>>create

Excel will ask you if you want to make the top row the header,you say yes.
Then you go to the cell where you want the dropdown to be.

When you are on that cell goto>>Data>>Validation
Say in dropdown= List
Type in next available box =and the header.
If not clear enough contact me via email

_________________
If you can help a friend in need,you are a friend indeed
SO~ if you can help you do so.

Ò¿Ó⌐
garethl@ij.co.za

[ This Message was edited by: gareth on 2002-04-26 01:39 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 02:14 PM	#1
jimmywanna Board Regular Join Date: Mar 2002 Posts: 182	I've done this recently. What i did was made a combobox from the "forms" toolbar. Then in the range prompt selected the range of options from the workbook. Then in another cell You make the "link". In the cell you want the selected option to appear type"Index=(First cell in range:last cell in range, link" it works a treat.

Apr 14th, 2002, 04:37 AM	#2
Ian New Member Join Date: Apr 2002 Posts: 1	Help ! I want to add a drop down combo box to cell. The drop down list will be linked to a range in the same workbook. I managed to do this but it was 3 years ago & I have forgot ! Any help are can anyone recommend and good book ? thanks Ian Bolton UK

Apr 14th, 2002, 04:45 AM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	See whether http://www.mrexcel.com/board/viewtop...5037&forum=2&2 helps.

Apr 26th, 2002, 02:38 AM	#4
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Dropdown boxes = Make a range which you want to copy into dropdown goto>>Insert>>name>>create Excel will ask you if you want to make the top row the header,you say yes. Then you go to the cell where you want the dropdown to be. When you are on that cell goto>>Data>>Validation Say in dropdown= List Type in next available box =and the header. If not clear enough contact me via email _________________ If you can help a friend in need,you are a friend indeed SO~ if you can help you do so. Ò¿Ó⌐ garethl@ij.co.za [ This Message was edited by: gareth on 2002-04-26 01:39 ]