'how to return a formula from user form
I am trying to multiply value in Textbox1 X Textbox2 using commandbotton1, so for example if Textbox1 = 3 and TextBox2 = 2.5 I would like to see result in textBox3 as formula including values from TextBox1&2 =3x2.5 i don't want to see result as value 7
Private Sub CommandButton1_Click() Me.TextBox3 = Me.TextBox1 * Me.TextBox2
End Sub
Solution 1:[1]
Like this ?
Private Sub CommandButton1_Click()
With Me
.TextBox3.Value = "=" & .TextBox1.Value & " * " & .TextBox2.Value
End With
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Spectral Instance |
