Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
11.4
11.5
12.0
12.1
12.2
12.3
12.4
12.5
13.0
13.1
Statistic
FMM
Blog
XL.FormControl.SetFmlaTxbx
Sets the source.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 13.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.FormControl.SetFmlaTxbx"; bookRef; sheetIndex; FormControlIndex; TxBx ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
| sheetIndex | The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
| FormControlIndex | The index of the from control Ranges from 0 to XL.Sheet.FormControlCount - 1. |
$formControlIndex |
| TxBx | The cell reference. |
Result
Returns OK or error.
Description
Sets the source.Sets the cell reference with the source data that the form control object's data is linked to.
Any cell range can be specified but only the first cell in the range is considered. This attribute applies only to label and edit box form controls.
See also
- XL.FormControl.GetFmlaGroup
- XL.FormControl.GetFmlaRange
- XL.FormControl.GetFmlaTxbx
- XL.FormControl.SetFmlaGroup
- XL.FormControl.SetFmlaLink
- XL.FormControl.SetFmlaRange
- XL.FormControl.SetMax
- XL.FormControl.SetMultiSel
- XL.LoadBook
- XL.Sheet.FormControlCount
Created 3th February 2023, last changed 3th February 2023
