Platforms to show: All Mac Windows Linux Cross-Platform
XLFormControlMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | XL | MBS XL Plugin | 21.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
This allows you to batch pre-fill form fields in an Excel document.
You may need Excel to create the template with the form fields.
New in LibXL 4.0.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
- 27 properties
- property AltText as String
- property Book as XLBookMBS
- property Checked as Integer
- property DefaultSize as Boolean
- property Disabled as Boolean
- property DropLines as Integer
- property Dx as Integer
- property FirstButton as Boolean
- property FmlaGroup as String
- property FmlaLink as String
- property FmlaRange as String
- property FmlaTxbx as String
- property Handle as Integer
- property Horiz as Integer
- property Inc as Integer
- property ItemCount as Integer
- property LinkedCell as String
- property ListFillRange as String
- property Locked as Boolean
- property Macro as String
- property Max as Integer
- property Min as Integer
- property MultiSel as String
- property Name as String
- property ObjectType as Integer
- property Print as Boolean
- property Sel as Integer
- 7 methods
- method AddItem(value as String)
- method ClearItems
- method Constructor Private
- method FromAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
- method InsertItem(Index as Integer, value as String)
- method Item(Index as Integer) as String
- method ToAnchor(byref Col as Integer, byref ColOff as Integer, byref Row as Integer, byref RowOff as Integer) as Boolean
- 15 constants
Check State
| Constant | Value | Description |
|---|---|---|
| CheckedTypeChecked | 1 |
Object is checked or selected. |
| CheckedTypeMixed | 2 |
Mixed selection. Applies only to check boxes. |
| CheckedTypeUnchecked | 0 |
Object is unchecked or unselected. |
Object Types
| Constant | Value | Description |
|---|---|---|
| ObjectTypeButton | 1 |
Button control |
| ObjectTypeCheckbox | 2 |
Check-box control |
| ObjectTypeDialog | 11 |
Dialog control |
| ObjectTypeDrop | 3 |
Drop-down (combo box) control |
| ObjectTypeEditbox | 10 |
Edit box control |
| ObjectTypeGbox | 4 |
Group box control |
| ObjectTypeLabel | 5 |
Label control |
| ObjectTypeList | 6 |
List box control |
| ObjectTypeRadio | 7 |
Radio button control |
| ObjectTypeScroll | 8 |
Scroll bar control |
| ObjectTypeSpin | 9 |
Spin box control |
| ObjectTypeUnknown | 0 |
Unknown control |
This class has no sub classes.
Some methods using this class:
- XLSheetMBS.FormControl(index as integer) as XLFormControlMBS
Blog Entries
- News from the MBS Xojo Plugins in version 21.5
- MonkeyBread Software Releases the MBS Xojo Plugins in version 21.5
Xojo Developer Magazine
- 21.1, page 21: News from MBS Xojo Plugins, What's up with MonkeyBread Software by Stefanie Juchmes
- 20.1, page 9: News
Release notes
- Version 21.5
- Added XLFormControlMBS class and related methods.
The items on this page are in the following plugins: MBS XL Plugin.
