In Microsoft Excel, if you try to link the value of a check box, option button, list box, scroll bar, or spinner control to a function, you
will receive the following error message:
The text you entered is not a valid reference or defined name.
Back to the top
You cannot link the value returned by a control to a formula or a function.
Back to the top
You can link the value of a control to a cell in a worksheet by
selecting the control and typing the reference to the cell in the formula
bar. You can also create a link using the
Cell Link box on the
Control tab of the
Format Control dialog box. When you link the value of a control to a cell, it is designed to be a two-way link, so that a change to the cell value changes the value of the control, and vice
versa. Because the control cannot change the value of a function, it is
not possible to link the value of a control to a worksheet formula or
a Visual Basic function.
Back to the top
For more information about Forms toolbar, click
Microsoft Excel Help on the
Help menu, type
Types of buttons, check boxes, and other controls on the Forms toolbar in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
Back to the top
Help and Support
