Help with a formatting problem - Textbox to sheet and back.

[gnaske]

Hi Forum.
This text below is in the attached workbook too..


I have a formatting problem.
But first...
- In Danish we use a dot as the 1000 separator.
- And a comma as the 2 digit decimal separator.
- Looks like this = 1.000,50

I want to type the amounts in a Userform.Textboxes.
To make the amount calculate on the sheet B4, I force the 2 digit decimal comma to change into a dot in the textbox, when typing a comma.
So far so good and I don't care if it shows a dot as the 1000 separator too, but if it can be fixed automatic to show the English comma and still is calculation in B4, it would be perfect.

Now my Problem.
When I close and open the Userform again
- It will not show the 1,000 separator dot (or comma).
- And it will only show 1 digit after the 2 diget decimal number, when I type a zero (0) as the last digit = When opening the Userform it shows 1000.5 instead of 1000,50.

Open the Userform to see how it will show in the Textboxes.
The codes is on the button in the VBA.

The codes to change the comma to the dot is on each Textbox.
Plus some other codes I tried to use, to see if they would work.



I really hope someone can help me and put the codes into my VBA, to resend it to me.
I always have these trouble with the formatting, when trying to make a Date or an amount/a number, because of the difference the English VBA and the Danish formatted Excel