replicate combo boxes

[Guest]

I have cells in 2 columns in a worksheet with combo boxes. How can I replicate the combo boxes down the columns so that every combo box has the correct Control Cell Link? I want each row to have its own combo in the relevant columns

Cell formula:- =INDEX(Controls!$A$2:$A$5,Log!L3,0) - this replicates OK using Ctrl + Dow
Control Input Range:- Controls!$A$2:$A$5 - this value stays constant
Control Cell Link:- Log!L3 - this value needs to change to Log!L4; Log!L5 etc.

 

[Jim Rech]

Controls do not have any neat fill down techniques like cell formulas do re
relative references. So, while you can select and copy a control, and then
select one destination cell after another and do a Ctrl-v to paste it, you
will have to edit each control's properties to link it to different cells.

--
Jim Rech
Excel MVP
|I have cells in 2 columns in a worksheet with combo boxes. How can I
replicate the combo boxes down the columns so that every combo box has the
correct Control Cell Link? I want each row to have its own combo in the
relevant columns.
|
| Cell formula:- =INDEX(Controls!$A$2:$A$5,Log!L3,0) - this
replicates OK using Ctrl + Down
| Control Input Range:- Controls!$A$2:$A$5 -
this value stays constant
| Control Cell Link:-
- this value needs to change to Log!L4; Log!L5 etc.

 

[Guest]

Thanks for the info, Jim