Text Box Formulas

New Contributor

Would it be possible to have text boxes that include formulas other than just a cell reference? I would like to be able to use XLookup in a text box.

Mark

2 Replies

@AngusMacgyver 

No, that is not possible. Formulas only work in worksheet cells.

You could place the formula you need in a cell and place a reference to that cell in the text box.

The cell can be in another sheet, even a hidden one if you prefer.

Hans,
Thanks!!! I was hoping this would be a feature that could be added to Excel.