Formating Textbox Problem 1

[max1565]

I have a column of money amounts that sre summed. The new amounts are entered from a textbox to a new sheet. The new items are then copied to the column that is being summed. The items that came from the textbox will not add. If i type the same number over the textbox it adds. This is driving me nuts!!!

Does anyone have any ideas. Sorry about the explanation, but it is kind of hard to explain. I tried formating the textbox results, but it did no good.

Thanks

 

[JESTAR]

Are you adding 2 strings together?

 

[max1565]

The textbox is used by the user to add new data to an existing database excel spreadsheet. One of the columns consists of the sale price of different houses. Monthly reports are generated from the database. One item that goes in the report is the sum of all sale prices. This is where the problem is. The dollar amounts will not add up. It has something to do with what the text box is placing in the column, because I can type in the same number to replace what the textbox put in and it adds up just fine.

Hope that explained it better.

Thanks

 

[Bowers74]

I am assuming that you are using Range("A1&quot = TextBox1, try using Range("A1&quot = Val(TextBox1). That might do the trick. Without being able to see which code you are using, it is a bit difficult to give a better answer.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[max1565]

I was using Range("A1&quot = TextBox1. I cahnged it to Range("A1&quot = Val(TextBox1)and it worked. Does that mean that before, excel was thinking that it was text?

Thanks Bowers74 :-D

 

[Bowers74]

I believe that the standard return value for a TexBox is text. Some people use Textbox1.Value, but I have found that you can't co wrong with Val(TextBox1) if you are using numbers!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!