Formula Editor/Bar in UserForm TextBox?

[Logit]

.
.
Paste this code in your UserForm for the CommandButton.

Option Explicit

Private Sub CommandButton1_Click()
    Sheets("Sheet1").Range("A3").Formula = TextBox1.Text
End Sub

This example presumes two numbers, one in A1 and one in A2 ..... with the total in A3.

ex: =SUM(A1:A2)

or

ex: =A1-A2

or

ex: =A1*A2

[xtinct2]

.
.
Paste this code in your UserForm for the CommandButton.

Option Explicit

Private Sub CommandButton1_Click()
    Sheets("Sheet1").Range("A3").Formula = TextBox1.Text
End Sub

This example presumes two numbers, one in A1 and one in A2 ..... with the total in A3.

ex: =SUM(A1:A2)

or

ex: =A1-A2

or

ex: =A1*A2

You'd have to type in the formula and cell references for this method. Is it possible to add a formula bar to the UserForm -- so that you can click a cell?