VBA - losing a decimal point in equation

[stegngas]

Hi

On UserFrame I have several TextBoxes in which a user inputs a value. The names of these textboxes begins with "tbtt". As you can see I have some equations here and there. The result of those must be seen in TextBoxes tbttUg1 and tbttHg1. The question is - why I lose my decimal point???

E.g. if a usser inputs in tbttA a value 10,52 and tbttUg1.value=25,12, the tbttHg1.value=2642624. Why do I lose my decimal point???

Furhemore, does anyone know any more elegant way to show the result of an equation somewhere that is not a textbox?

Thanks for any kind of help!

Please Login or Register  to view this content.

[Bernie Deitrick]

I don't think VBA likes commas as decimals....

tbttHg1.Value = CDbl(Replace(tbttA.Value, ",", ".")) * CDbl(Replace(tbttUg1.Value, ",", "."))

[stegngas]

Hi, still doesn't work. It works only, if copy the input value from textbox to another textbox. But if I try to multiply it with some other, the problem doesn't go away. Don't know why is that happening.

An input value from combobox is e.g. "1.5", input value from textbox is "1,5", if i multiply this in another textbox where I used CDbl and Replace command for textbox, the result is 22.5.
Strange.

Do you have any other suggestions?

[MrShorty]

I think Bernie was on the right track. Since you have not posted a sample, I put together the following bare bones simple code:

Please Login or Register  to view this content.

With my standard US number settings (in Windows control panel) of "." for decimal separator and "," for thousands separator, the output of this code is 1.5 -- 15 -- 22.5. If I change my Windows settings to use "," for decimal and "." for thousands separators, the output changes to 15 -- 1,5 -- 22,5. It appears, as Bernie suggested, that VBA is not correctly interpreting the comma as a decimal separator. If you are going to allow both "." and "," to be used as decimal separators, you are going to need to somehow code the procedure to recognize both formats. Easiest approach might be to pick one character for the decimal separator (either "." or "," consistent with your Windows settings) and consistently use that character.