XL2000: Can't Link Value of Control to Function (214296)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214296

SYMPTOMS

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.

CAUSE

You cannot link the value returned by a control to a formula or a function.

MORE INFORMATION

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.

REFERENCES

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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kberrmsg kbprb kbui KB214296
©2003 Microsoft Corporation. All rights reserved.