| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
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; FormControlIndexOrName; 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 |
| FormControlIndexOrName | The index or name of the from control. Index 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.Book.SheetCount
- XL.FormControl.GetFmlaLink
- XL.FormControl.GetFmlaRange
- XL.FormControl.GetFmlaTxbx
- XL.FormControl.SetFmlaGroup
- XL.FormControl.SetFmlaLink
- XL.FormControl.SetMax
- XL.FormControl.SetMultiSel
- XL.LoadBook
- XL.Sheet.FormControlCount
Blog Entries
Created 3th February 2023, last changed 3th February 2023
