View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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 ....)