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.GetFmlaTxbx
Queries the source for the control.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 13.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.FormControl.GetFmlaTxbx"; bookRef; sheetIndex; FormControlIndex ) 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 |
Result
Returns text or error.
Description
Queries the source for the control.Returns 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.
See also
- XL.Book.SheetCount
- XL.FormControl.GetFmlaGroup
- XL.FormControl.GetFmlaLink
- XL.FormControl.GetFmlaRange
- XL.FormControl.GetMax
- XL.FormControl.GetMultiSel
- XL.FormControl.SetFmlaRange
- XL.FormControl.SetFmlaTxbx
- XL.LoadBook
- XL.Sheet.FormControlCount
Created 3th February 2023, last changed 3th February 2023
