Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLFormControlMBS class.

XLFormControlMBS.AltText as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Alternative text for the object.

(Read only property)

XLFormControlMBS.Book as XLBookMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The book reference.

(Read only property)

XLFormControlMBS.Checked as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether a check box is selected or a radio button is selected.

This attribute only applies to check box and radio button form controls.

See CheckType* constants.
(Read and Write property)

XLFormControlMBS.DefaultSize as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the object is at its default size.

(Read only property)

XLFormControlMBS.Disabled as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the object is allowed to run an attached macro.

(Read only property)

XLFormControlMBS.DropLines as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the number of lines in the drop-down before scroll bars are added.

This attribute only applies to drop-down form controls.
This value must be at least 0 and at most 30000.
(Read and Write property)

XLFormControlMBS.Dx as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the width of the scroll bar in pixels.

This attribute only applies to list boxes, scroll bars, spin boxes and drop-downs.
(Read and Write property)

XLFormControlMBS.FirstButton as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the object is the first button in a set of radio buttons.

This attribute only applies to radio button form controls.
(Read and Write property)

XLFormControlMBS.FmlaGroup as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The cell reference in a group box is linked to.

Only applies to group box form controls.
(Read and Write property)

XLFormControlMBS.FmlaLink as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The cell reference is linked to.

Only applies to check boxes, radio buttons, scroll bars, spin boxes, drop-downs and list boxes.
(Read and Write property)

XLFormControlMBS.FmlaRange as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The cell reference with range of source data cells.

This attribute only applies to list box and drop-down form controls.
(Read and Write property)

XLFormControlMBS.FmlaTxbx as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The cell reference with the source data that the form control object's data is linked to.

This attribute applies only to label and edit box form controls.
Any cell range can be specified but only the first cell in the range is considered.
(Read and Write property)

XLFormControlMBS.Handle as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The internal object reference.

(Read only property)

XLFormControlMBS.Horiz as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns whether the scroll bar is horizontal.

This attribute only applies to scroll bar form controls.
(Read and Write property)

XLFormControlMBS.Inc as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The change in the current value of a scroll bar or a spin box form control as a result of on an increment click.

It must be at least 0 and at most 30000. This attribute applies only to scroll bar or spin box form controls.
(Read and Write property)

XLFormControlMBS.ItemCount as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the number of items in a list box or drop-down form control.

(Read only property)

XLFormControlMBS.LinkedCell as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The worksheet range linked to the control's value.

(Read only property)

XLFormControlMBS.ListFillRange as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The range of source data cells used to populate the list box.

(Read only property)

XLFormControlMBS.Locked as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the object is locked when the sheet is protected.

(Read only property)

XLFormControlMBS.Macro as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The custom function associated with the object.

(Read only property)

XLFormControlMBS.Max as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The maximum value generated by the scroll bar or by the spin box.

It must be at least 0 and at most 30000. This attribute only applies to scroll bars and spin boxes.
(Read and Write property)

XLFormControlMBS.Min as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The minimum value generated by the scroll bar or by the spin box.

It must be at least 0 and at most 30000. This attribute only applies to scroll bars and spin box.
(Read and Write property)

XLFormControlMBS.MultiSel as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The indices of selected items as a comma-delimited list.

The list indices are one-based.
This attribute is valid only if the attribute selType has the value "multi".
This attribute applies only to list box form controls.
(Read and Write property)

XLFormControlMBS.Name as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The name for this embedded control.

(Read only property)

XLFormControlMBS.ObjectType as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the form control object type.

See ObjectType constants.
(Read only property)

XLFormControlMBS.Print as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Whether the object is printed when the document is printed.

(Read only property)

XLFormControlMBS.Sel as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The index of the selected item.

The index is one-based.
If set to a value of 0, no items are selected.
This attribute applies only to list box and drop-down form controls.
(Read and Write property)

The items on this page are in the following plugins: MBS XL Plugin.


The biggest plugin in space...