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. |
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 |
All times are GMT +1. The time now is 09:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com