Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I copy a combo box in Excel 2002 with a relative cell link?
Would like to create multiple combo boxes by copying and pasting a cell
containing a combo box but would like for the cell link for each combo box to be a relative cell reference so that the cell link is different for each combo box. Have tried changing the cell link to a relative reference before copying, but has no effect. |
#2
|
|||
|
|||
The code would depend on what kind of combobox you used.
Did you use a combobox from the control toolbox toolbar or a DropDown from the Forms toolbar? And a couple of alternatives. Maybe data|validation. It kind of looks the same. http://www.contextures.com/xlDataVal01.html (Debra Dalgleish's site) or even add all the comboboxes (or dropdowns) at one time. Or even just have one combobox (or dropdown) and have it move to a different cell (and adjust its linkedcell when you move it). If the values in the list are always the same (and it sounds that way since you're copy|pasting), having one combobox that moves maybe easier on excel. Bozo wrote: Would like to create multiple combo boxes by copying and pasting a cell containing a combo box but would like for the cell link for each combo box to be a relative cell reference so that the cell link is different for each combo box. Have tried changing the cell link to a relative reference before copying, but has no effect. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 crashes | New Users to Excel | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Excel 2002 not working | Setting up and Configuration of Excel | |||
Combo box copy data | Excel Discussion (Misc queries) | |||
How do I use Template wizard add in for 2002 Excel in 2003 excel?. | Excel Worksheet Functions |