Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bozo
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 crashes Veena New Users to Excel 0 February 16th 05 11:29 AM
Can you use excel 2003 version with excel 2002 and 2000 on a netw. cct Excel Discussion (Misc queries) 1 January 19th 05 01:11 AM
Excel 2002 not working Help IN Nebraska. Setting up and Configuration of Excel 2 December 22nd 04 11:29 AM
Combo box copy data Steve Excel Discussion (Misc queries) 1 December 22nd 04 01:00 AM
How do I use Template wizard add in for 2002 Excel in 2003 excel?. TCIrish Excel Worksheet Functions 0 November 23rd 04 05:43 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"