# FormulaMode Property

> Sets whether a TXRulerBar shows table cell references in A1 or R1C1 notation: rlNone (default), rlAuto for formula cells or rlAlways in any table cell.

- **Product:** TX Text Control ActiveX
- **Section:** Documentation
- **Kind:** Property
- **Path:** TX Text Control ActiveX > API Reference > TXRulerBar > FormulaMode Property
- **254 words**
- **Web URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/formulamode-property/
- **LLMs URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/formulamode-property/llms.txt
- **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/formulamode-property/llms-full.txt

---

Gets or sets a value specifying whether the ruler bar shows cell references when the current input position is in a table cell. Depending on the [TXTextControl.FormulaReferenceStyle](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/formulareferencestyle-property/llms-full.txt) property cell references are shown either in the A1 or in the R1C1 notation. This property has no effect when the [Appearance](https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/appearance-property/llms-full.txt) property has been set to **tx3D**.

Introduced: 26.0.

### Syntax

```vbscript
TXRulerBar.FormulaMode [= value]
```

| Setting | Description |
|---|---|
| 0 - rlNone | (Default). The ruler bar does not show cell references. |
| 1 - rlAuto | The ruler bar only shows cell references when the text input position is in a table cell containing a formula. |
| 2 - rlAlways | The ruler bar shows cell references when the text input position is in a table cell. When the input position changes to another cell, all references are shown relative to this new cell. |

### Data Types

Integer.

### See Also

- [Programming Category: Tool Bars](https://docs.textcontrol.com/tx-text-control-activex/reference/categories/toolbars/llms-full.txt)

---

## Nearby

- **Previous:** [EnablePageMargins Property](https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/enablepagemargins-property/llms-full.txt)
- **Next:** [hWnd Property](https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/hwnd-property/llms-full.txt)