If you click the following items in a worksheet multiple times or if you move a vertical toolbar over a worksheet with any of the following items

•	list box
•	drop-down list box (Microsoft Excel versions 5.0 or 7.0 only)
•	combo box (Microsoft Excel 97 only)

the following message may appear:

Back to the top

This problem may occur when the following conditions are true.

•	The Input range of the control is linked to a second worksheet. -and-
•	You zoom both worksheets to percentages other than 100 percent. -and-
•	The zoom percentage of the two sheets are not equal. -and-
•	You move a toolbar over the control, click the control and choose values, or you alternately select each of the two worksheets.

NOTE: Sometimes an action does not result in the message, but repeated actions do. The message only occurs when the worksheet that contains the control is active.

Back to the top

To work around this problem, do any of the following:

•	Change the zoom setting of either worksheet to 100 percent. Click Zoom on the View menu, click 100% and click OK. -or-
•	Change the zoom setting of both sheets to the same percentage. Click Zoom on the View menu to make this change. -or-
•	Select an input range that is on the sheet with the list box, drop-down list box, or combo box.

Back to the top

Changing the Input Range of a Control

To change the input range of a control, follow these steps:

1.	Hold down the CONTROL key and click the form control to select the control.
2.	On the Format menu, click Control.
3.	Click the Control tab and type a range on the active worksheet.

Back to the top

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Back to the top

Microsoft Excel 97

For more information about list boxes, combo boxes and input ranges, click Contents And Index on the Help menu, click the Index tab in Excel Help, type the following text

   list boxes
				

and then double-click the selected text to go to the "About control properties for list boxes and combo boxes" topic. If you are unable to find the information you need, ask the Office Assistant.

Back to the top

Microsoft Excel Version 7.0

For more information about list boxes, combo boxes, and input ranges, click Microsoft Excel Help Topics on the Help menu, click the Index tab in Excel Help, type the following text

   list boxes, linking to cell data
				

and then double-click the selected text to go to the "Linking controls to a cell or range" topic.

Back to the top