MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cell link


Posted by Travis on November 02, 2001 8:35 AM

Hello everybody, I am trying to create a combo box where I have formulas associated with it. But when I go to format control and don't have any idea about what the cell link suppose to link to. I have the ranges that I want but I don't know what/how to link the cell with.


Posted by Mark W. on November 02, 2001 9:50 AM

Cell link is the cell where the combo box stores
the index of the chosen item. For, example
suppose that your list consisted of...
{apples;oranges;bananas} and you chose "bananas".
A 3 would be stored in the cell that you
selected as the cell link... because "bananas"
is the 3rd item in the list.