Forum Discussion
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.
Hans,
Thanks!!! I was hoping this would be a feature that could be added to Excel.
Thanks!!! I was hoping this would be a feature that could be added to Excel.