XL98: Cannot Change Value for Form Control on a Worksheet

ID: q180373

The information in this article applies to:


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


This problem may occur when the form control is linked to a merged cell.


To work around this problem, unmerge the cell to which the control is linked. To do this, follow these steps:

  1. Press and hold the CONTROL key and click the form control. Click Format Control.

  2. Click the Control tab in the Format Control dialog box. Make note of the cell address in the Cell Link box and click Cancel.

  3. Select the cell that is referenced in the Cell Link box.

  4. Click Cells on the Format menu, click the Alignment tab, clear the Merge Cells check box, and then click OK.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: XL98 checkbox listbox dropdown optionbutton combobox scrollbar

Keywords          : kbprg xlformat xlvbmigrate 
Version           : MACINTOSH:98
Platform          : MACINTOSH 
Issue type        : kbbug 

Last Reviewed: July 2, 1999