Formula Editor/Bar in UserForm TextBox?

Hi,

I have a Userform w/ text boxes who's inputted value populates a certain cell (currently only supports static values).
Is it possible to have a userform textbox mimic a formula editor/bar so that the imputted values can be formulas that you can either type or click the relevant cells to write?

Example of the formula editor/bar I'm thiking of -- (basically can i add this to a user form)?:

formula bar.png

This way, end users can write a formula and that formula will be the text box's value, which will then populate the predetermined cell -- still as a formula (i.e. the value in the cell that the texbox populates is not static, but a dynamic formula)

This would help a ton, if possible!
Let me know if unclear

Thank you!

Originally Posted by AlphaFrog

Try this syntax.

Please Login or Register  to view this content.

This doesn't work like a formula bar -- you can't click the cells you're referencing, and you'd have to type out the formula like text.
Is there a way to make it work like a formula bar, or just add a formula bar to the textbox (see the image in original post)?
Thanks