Adding Numbers with TextBox Controls on an Excel VBA UserForm

[@RightToSalute]

You are Most talented person in the world ...

[@santosozhang1985]

Thanks a lot for the lesson. Very Useful.

[@craigcottrellgm4816]

Thanks for all you do out here! I'm not sure what mistake I'm making but I never get, TypeName(Me.ActiveControl) = "TextBox". If I put in, MsgBox TypeName(Me.ActiveControl), it returns Frame. It is for sure, a TextBox I'm changing! I know this isn't a forum... and you a busy man.. But hey, it cant hurt to ask.

[@joelssamsonjr.9271]

How about if i wanted to Minus?

[@sumanparida9957]

In a Textbox I want to write email id. If I put any name or number then I want to get an error. So how to write code for that in VBA user form? Please help it's urgent.

[@arpanosso]

Perfect.... tks!!!

[@DrGrande]

You're welcome -