Hi all,

i hope you can help.

Due to different regional settings used, and especially the decimal (,) or (.), I have been making use of the code below to allow for the capture of (.) when the regional decimal is set to (,).

But this obviously only allows me to capture using the (.), but then changes the (.) back to (,) based on the regional decimal settings.

How can i force format my values captured throughout my UserForm to be (.)? I.e., when saving to excel, may decimal in my values will be (.), regardless of my regional settings.

Public Function ChangeFStoComma(ByRef KeyAscii As MSForms.ReturnInteger)
        If KeyAscii = Asc(".") Then KeyAscii = Asc(",")
End Function
Private Sub txtRecordChangeCode1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    ChangeFStoComma KeyAscii
End Sub
Thank you!