Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

XL.FormControl.SetFmlaLink

Sets the cell reference is linked to.

Component Version macOS Windows Linux Server iOS SDK
XL 13.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.FormControl.SetFmlaLink"; bookRef; sheetIndex; FormControlIndexOrName; LInk )   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
LInk The new link value.

Result

Returns OK or error.

Description

Sets the cell reference is linked to.
Only applies to check boxes, radio buttons, scroll bars, spin boxes, drop-downs and list boxes.

See also

Blog Entries

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


XL.FormControl.SetFmlaGroup - XL.FormControl.SetFmlaRange