Hello, I hope someone can help me on this. I have this userform to add and edit a database. My computer’s regional setting at work for decimal separator is set to comma and my problem still occurs if I change it to dot*.
When adding new data in userform my code is set to force dots over comas and then recognize and transfer numbers with isnumeric Function in my database. The data is added with a dot to the database.
However, when I want to edit, the userform loads the numbers but automatically replace the dots with comas. If I save again, the numbers after the decimals will be erased in the database.
I suspect my « edit » code to be the problem as it imports numbers back to my userform.
*I’ve tried changing windows settings to use the dot as decimal separator. It works for a while, but stops working after a windows reboot even if the dot is still the decimal separator, which is odd.
Any idea on how to fix this?
Thanks
Bookmarks