Punctuation in VBA calculations

[jose001]

Morning everyone,

I'm looking for a little advice if anyone has any suggestions.
I have a very basic vba form with two TextBox's and a button. The user enters a floor area in the first textbox and this change determines the value that excel places in the second. The button simply pastes the value in the second box onto a spreadsheet. I’m using if statements to calculate the value i.e

 If x = 0 Then
TextBox2.Value = "0"
ElseIf x <= 99 Then
TextBox2.Value = "150.00"

but I’m having issues with punctuation. Excel treats 1500 differently to 1,500. What would be the best way to overcome this. Should I check for punctuation and then remove it? Obviously the simplest solution is to just tell people not to use “ , “ but unfortunately people vary rarely read instructions lol

Any help greatly appreciated

Many Thanks

 

[Richard Schollar]

You could remove commas using Replace:

x = Val(Replace(Textbox1,",",""))

for example.

 

[Legacy 167133]

Try to change, TextBox2.Value = "150.00" to TextBox2.Value2 = "150.00", and if that does not work try TextBox2.Text = "150.00"

 

[jose001]

Thanks for the advice guys, very much appreciated. I've gone with Richard's suggestion which has worked a treat.

Thanks again.