XL2000: Can't Link Value of Control to Function

• Microsoft Excel 2000

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 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.

Additional query words: XL2000

Keywords : kberrmsg kbui kbdta xlui xldraw xlformula
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb