Anonymous
06-26-2003, 08:19 AM
Cell Link for combo box in Excel : Relative or absolute?
Well, using only 1 combo box is fine without caring about cell link's being relative or absolute. But when I copy the cell containing the combo box, I need the cell link to be relative.
Here's something to visualize the problem:
Think of an order form. I got 100 orders in the list. And I got a column which I want to put a combo box with selections "paid" or "not paid" . Well, I put my first combo box in my first order. But when I copy that cell down for the remaining 99 orders, all the combo boxes that I created (for the other 99 orders) all are linked to the FIRST order's combo box's cell reference. However I want that cell's reference to be relative so that when I copy the cell(and the combo box as well, as that cell contains containing the combo box) their cell link is changed. I need this cos I may have 10000 orders for example and modifying all the cell refeences of all those orders's combo boxes may be annoying.
Any help is welcomed. Thanks in advance.
Well, using only 1 combo box is fine without caring about cell link's being relative or absolute. But when I copy the cell containing the combo box, I need the cell link to be relative.
Here's something to visualize the problem:
Think of an order form. I got 100 orders in the list. And I got a column which I want to put a combo box with selections "paid" or "not paid" . Well, I put my first combo box in my first order. But when I copy that cell down for the remaining 99 orders, all the combo boxes that I created (for the other 99 orders) all are linked to the FIRST order's combo box's cell reference. However I want that cell's reference to be relative so that when I copy the cell(and the combo box as well, as that cell contains containing the combo box) their cell link is changed. I need this cos I may have 10000 orders for example and modifying all the cell refeences of all those orders's combo boxes may be annoying.
Any help is welcomed. Thanks in advance.