Actually it isn't an oddity. The plus sign was the original concatenation
operator. So if you + two strings, you get concatenation. Values in
textboxes are strings even if they are numeric in nature.

--
Regards,
Tom Ogilvy


"Leith Ross" wrote
in message ...

Hello Gary,

Its one of those VBA oddities. It's a good practice not to rely on the
system to decide what math function to perform on string data. Change
your code to this and it will work fine regardless of what you do.

N = Val(TextBox1.Value) + Val(TextBox2.Value)

N will equal 15

TextBox.Value doesn't return a numeric value. It simply returns what is
currrently diplayed by the TextBox.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=484631