Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

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.

Re: cell link

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.