textbox.value doesn't create a number?

  • Thread starter Thread starter Larry Levinson
  • Start date Start date
L

Larry Levinson

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 ....)
 
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 said:
Larry,

Try something like

MsgBox CLng(TextBox1.Text) + CLng(TextBox2.Text)
Click to expand...

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