Oct 31 2022 08:35 AM
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
Oct 31 2022 02:36 PM
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.
Oct 31 2022 02:38 PM