Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to give cell reference using Combo Boxes in Excel?
Hi, is it possible to have Combo Boxes in cells in Excel?
How could I link a particular cell in excel with the selected value from the combobox. Kindly help me in this regard. Joseph J |
#2
|
|||
|
|||
Hi Joseph
See http://www.contextures.com/xlDataVal01.html for several approaches on this. HTH. Best wishes Harald "Joseph" skrev i melding ... Hi, is it possible to have Combo Boxes in cells in Excel? How could I link a particular cell in excel with the selected value from the combobox. Kindly help me in this regard. Joseph J |
#3
|
|||
|
|||
i prefer the combo box from the forms toolbar.When you right click on the
combo box you get the format control box which lets you select your data range for your list AND a cell link.The cell link will show 1 for the first item in your list 2 for the second etc etc....you can use that link in choose formulas,row numbers, column numbers etc etc -- paul remove nospam for email addy! "Joseph" wrote: Hi, is it possible to have Combo Boxes in cells in Excel? How could I link a particular cell in excel with the selected value from the combobox. Kindly help me in this regard. Joseph J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Static cell reference | Excel Worksheet Functions | |||
Is it possible to re-link a cell back to a combo box? | Excel Discussion (Misc queries) | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions |