Hi,

How about this

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
MySum = Evaluate(TextBox1.Text)
End Sub

Mike

"Orion Cochrane" wrote:

I have a userform that is used to enter different data, and sometimes I have
to enter a formula in the textbox. Is there a way, using my existing
txtField_Exit events to calculate the value if I enter something like "=2+2"
and it gives me the answer when I tab away from the active textbox?
--
I am running on Office 2003, unless otherwise stated.