Changing thousand separator in Excel

Hi

I have the following problem: I have an userform with a textbox on for which I want to offset the value. I have formatted the textbox so that if you type in "10000", it shows the value as "10.000", i.e. with separator, in the textbox. However, once I try and offset the value into my sheet, Excel reads the dot/period as decimal and not as a thousand separator. So once I return to my sheet, the value is no longer "10.000", but "10". I guess the problem arises because VBA uses periods/dots as decimal separators and commas as thousand separators, but my Danish excel version uses the opposite.

Is there a way where I can change this?

Any help is appreciated!

If your regional settings use the . as thousands separator, you can convert the textbox using CDbl:

Please Login or Register  to view this content.

for example.