textbox.value doesn't create a number?
 

Obviously, I am mistaken, but I thought if i told a userform wth text
boxes on it to treat the inputs as numbers, they would become numbers.

I tried to add two numbers that were in the text boxes, but instead of
a + b, I got the string, ab ... any suggestions?


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)

textbox.value doesn't create a number?
 

Larry,

Try something like

MsgBox CLng(TextBox1.Text) + CLng(TextBox2.Text)


--

HTH

Bob Phillips

"Larry Levinson" wrote in message
...
Obviously, I am mistaken, but I thought if i told a userform wth text
boxes on it to treat the inputs as numbers, they would become numbers.

I tried to add two numbers that were in the text boxes, but instead of
a + b, I got the string, ab ... any suggestions?


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)

textbox.value doesn't create a number?
 

or, this:

bn_first = Sheets("Japan").Range("c10000").Value +
Sheets("Japan").Range("e10000").Value

once I stuff the data on the sheet, that is.
"Bob Phillips" wrote:

Larry,

Try something like

MsgBox CLng(TextBox1.Text) + CLng(TextBox2.Text)

Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)