MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy a Combo box

Posted by Jay on July 12, 2001 8:45 AM

I have a combo box on one line of my spreadsheet. The combo box is filled by an Input Range to another area of the spreadsheet via direct connection ie. $B$1, $C$50. I put the result in a the cell link using a variable connection ie A1. When I copy the combo box to the next row, I want the direct connection for the data to be the same (and it is) and the variable connection to advance to A2 (which is does not). Is there anyway to copy a combo from one row to another and have the result Cell Link to move down one row?

Thanx in advance.


Posted by Tuc on July 12, 2001 8:52 AM

The first thing I would try is not to use abosolute addressing ($B$1:$C$50) Change this value to relative addressing (B1:C50) and that might solve your problem.