The information in this article applies to:
SYMPTOMSWhen you click an option button, check box, list box, combo box, scroll bar or spinner control on a worksheet, the control does not change as expected. For example, when you click a list box, the selected item in the list does not change. Also, the cell link value does not change. CAUSEThis problem may occur when the form control is linked to a merged cell. WORKAROUNDTo work around this problem, unmerge the cell to which the control is linked. To do this, follow these steps:
STATUSMicrosoft 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. Additional query words: XL97 checkbox listbox dropdown optionbutton combobox scrollbar 8.0 8.00
Keywords : xlformat xlvbmigrate |
Last Reviewed: November 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |