Mat
Well-known Member
- Joined
- Sep 17, 2003
- Messages
- 509
Hi,
I have a problem, I know the decimal separator is the source, but I don't understand why...
Here is the situation :
I have a form with textboxes and a command button...
User fill the textboxes with the value they want, once it is done, press the ok button (commandbutton) and all the value are put in different cell..
As simple as This :
Private Sub OkButton_OnClick()
Range("A1").Value = TextBox1.Value
End Sub
Ok now, my decimal separator is the ","
In the textboxes, the user may enter both 1.1 or 1,1
The result in Range ("A1") will be 1,1 at screen. (in both case)
and in B1 I could without problem do : =A1*2, and it will give me 2,2
THe real problem is there :
My cell A1 is formatted with a personnalised format number :
Now if I enter manually 1,1 into cell A1, I see :
Just as expected...
but if I use the Form, I get in the cell 1,1 without the "Greater Than" symbol, just as if it was text in the cell, but I still could use the value in other formula... if I want to get back the "Greater Than" symbol, i must select A1, click in the Formula bar, and press enter (without any change) to make it appear...
if I use the "." as decimal separator, I have no problem...
...
What happens?!
I have a problem, I know the decimal separator is the source, but I don't understand why...
Here is the situation :
I have a form with textboxes and a command button...
User fill the textboxes with the value they want, once it is done, press the ok button (commandbutton) and all the value are put in different cell..
As simple as This :
Private Sub OkButton_OnClick()
Range("A1").Value = TextBox1.Value
End Sub
Ok now, my decimal separator is the ","
In the textboxes, the user may enter both 1.1 or 1,1
The result in Range ("A1") will be 1,1 at screen. (in both case)
and in B1 I could without problem do : =A1*2, and it will give me 2,2
THe real problem is there :
My cell A1 is formatted with a personnalised format number :
Code:
"> "0
Now if I enter manually 1,1 into cell A1, I see :
Code:
> 1,1
but if I use the Form, I get in the cell 1,1 without the "Greater Than" symbol, just as if it was text in the cell, but I still could use the value in other formula... if I want to get back the "Greater Than" symbol, i must select A1, click in the Formula bar, and press enter (without any change) to make it appear...
if I use the "." as decimal separator, I have no problem...
...
What happens?!