Microsoft KB Archive/211722

= XL2000: Context-Sensitive Help Not Available for Some Form Controls =

Article ID: 211722

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211722





SYMPTOMS
When viewing the Format Control dialog box for a Forms toolbar control, if you click the Help button (the question mark in the upper-right corner of the title bar) on the Control tab, and then click an item in the dialog box, you may receive the following error message:

No Help topic is associated with this item.



CAUSE
Context-sensitive Help topics are not associated with the following controls on the Forms toolbar:

Check Box

Option Button

Combo Box

Scroll Bar

Group Box

Spinner

List Box



RESOLUTION
The Help information that is not available on the Control tab in the Format Control dialog box is listed in the following table.   Item                      Help information --  3D Shading                To give the selected control a three- dimensional appearance, select the 3D Shading check box.

Cell Link                To link the value of the selected control to                             a cell on a worksheet, either type the cell address in the Cell Link box; or place the insertion point in this box, and then select a                            cell.

Current Value            To set the initial value for the selected scroll bar or spinner, type an integer in                            the Current Value box. This integer must fall between the Minimum Value and Maximum Value you set for this control.

Drop Down Lines          To specify the number of lines displayed in                             the drop-down portion of the selected drop- down list box, type a number in the Drop Down Lines box. If the number you specify is                            less than the number of items in the list, a                             scroll bar appears to the right of the list.

Incremental Change       To specify how much the value of the selected scroll bar or spinner changes when the user clicks one of its arrows, type an                            integer in the Incremental Change box.

Input Range              To fill the selected list box with the contents of a range of cells on a worksheet, either type the range address in the Input Range box; or place the insertion point in                            this box, and then select a range.

Maximum Value            To set the maximum value for the selected scroll bar or spinner, type an integer in                            the Maximum Value box. The value in this box must be greater than the value in the Minimum Value box.

Minimum Value            To set the minimum value for the selected scroll bar or spinner, type an integer in                            the Minimum Value box. The value in this box must be less than the value in the Maximum Value box.

Page Change              To specify how much the value of the selected scroll bar changes when the user clicks inside the scroll bar on either side of the scroll box, type an integer in the Page Change box.

Selection Type - Extend  To specify extendible selection for the selected list box, click Extend. When the custom dialog box runs, the user will be                            able to select multiple items by clicking the first item in a series, and then holding down SHIFT and pressing the last item in the series. Both clicked items and all items in                            between will be selected. The user can select or deselect an individual item by                            holding down CTRL and clicking the item.

Selection Type - Multi   To specify a multiple-item selection for the selected list box, click Multi. When the custom dialog box runs, the user will be                            able to select any assortment of items in                             the list. The user must select and deselect items one at a time.

Selection Type - Single  To specify single-item selection for the selected list box, click Single. When the custom dialog box runs, the user will be                            able to select one item at a time from the list.

Value - Checked          To set the initial state of the selected check box or option button to on, click Checked.

Value - Mixed            To set the initial state of the selected check box to mixed, click Mixed. The check box will contain a dimmed check mark when the dialog box first opens.

Value - Unchecked        To set the initial state of the selected check box or option button to off, click Unchecked.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbbug kbpending KB211722

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.