XL.FormControl.SetFmlaTxbx
--------------------------

Sets the source.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [13.1](newinversion131.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.FormControl.SetFmlaTxbx"; BookRef; SheetIndex; FormControlIndexOrName; TxBx ) 

**MBS**( **"XL.FormControl.SetFmlaTxbx";** /\* Sets the source. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$SheetIndex**; /\* The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1.e.g. 0 \*/   
**$FormControlIndexOrName**; /\* The index or name of the from control.  
Index ranges from 0 to [XL.Sheet.FormControlCount](XLSheetFormControlCount.md) - 1.e.g. $formControlIndex \*/   
**$TxBx**) /\* The cell reference. \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| SheetIndex | The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1. | 0 |
| FormControlIndexOrName | The index or name of the from control.   Index ranges from 0 to [XL.Sheet.FormControlCount](XLSheetFormControlCount.md) - 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](XLBookSheetCount.md)
- [XL.FormControl.GetFmlaGroup](XLFormControlGetFmlaGroup.md)
- [XL.FormControl.GetFmlaLink](XLFormControlGetFmlaLink.md)
- [XL.FormControl.GetFmlaRange](XLFormControlGetFmlaRange.md)
- [XL.FormControl.SetFmlaGroup](XLFormControlSetFmlaGroup.md)
- [XL.FormControl.SetFmlaLink](XLFormControlSetFmlaLink.md)
- [XL.FormControl.SetFmlaRange](XLFormControlSetFmlaRange.md)
- [XL.FormControl.SetMax](XLFormControlSetMax.md)
- [XL.FormControl.SetMultiSel](XLFormControlSetMultiSel.md)
- [XL.Sheet.FormControlCount](XLSheetFormControlCount.md)

### Blog Entries

- [New in MBS FileMaker Plugin 13.1](https://www.mbsplugins.de/archive/2023-03-15/New_in_MBS_FileMaker_Plugin_13/monkeybreadsoftware_blog_filemaker)

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

  
[XL.FormControl.SetFmlaRange](XLFormControlSetFmlaRange.md) - [XL.FormControl.SetHoriz](XLFormControlSetHoriz.md)

[HTML Version](XLFormControlSetFmlaTxbx.shtml)