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  


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


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.
TxBx The cell reference.


Returns OK or error.


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

Created 3th February 2023, last changed 3th February 2023

XL.FormControl.SetFmlaRange - XL.FormControl.SetHoriz

💬 Ask a question or report a problem

Start Chat