Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ....) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ....) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ....) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number format TextBox? | Excel Discussion (Misc queries) | |||
How to create a Textbox in a standalone Excel 2007 chart using mac | Charts and Charting in Excel | |||
Verify Textbox Information is a Number and Not Text | Excel Discussion (Misc queries) | |||
Assigning Row Number to TextBox | Excel Discussion (Misc queries) | |||
Userform textbox number formats | Excel Discussion (Misc queries) |