## Forum Discussion

AngusMacgyver

Oct 31, 2022Copper Contributor

# Text Box Formulas

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

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.

- AngusMacgyverCopper ContributorHans,

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