I'm having a problem in my vba code.
I have a userform with some text boxes and the values that I enter when i run the code are not what i want.
I put a value like " 0.23" in the text box and if i insert a msgbox to return me the value inserted it shows 23, but the value is inserted in the worksheets of excel has 0.23 !?!
The text box is defined as "preco" and then i have something like this:
prc = preco.Value
MsgBox prc ' shows me 23!!!
When i select a cell in excel to input the value it appears 0.23 but then i have : prc * quantidade.Value
and i get the "quantidade.value" * 23 and not the 0.23