Hi people,
I have a little issue which i dont know how solve.
i've got a userform with a textbox on it and with this textbox i want to have it the same behaviour as the normal cell on a sheet that has the financial properties.
So what i want to have is when u exit the textbox i want to run this script:
Altough it works fine, i have 2 small issues with them.
When you fill in the textbox trough ur numblock you have the button as " . "(dot)
However when this button is used on a normal cell it results as a " , " (comma) but again in the userform it results a " . " (dot)
Because of this the format doesnt give the proper result, but multiplying the result * 100
Exc: If u write "123.45" the format function makes it "€12.345,00" while it should be made "€123,45"
This is because the dot is not changed in a comma, like its done normaly in a worksheetcell
So when u entered the textbox i want to change dot to a comma once this one is typed in.
The next thing is that i want the € starting in the text box at the whole left while the values start at the whole right. just like the cell properties, "financial"
Bookmarks