Replacing dot by a comma

[mqdias]

Hi.

I would like to create a macro witch can detect dots in a textbox value and replace them by commas. I intend this because this is an issue that can only be overcomed by changing the Regional and Language Properties in the Control Panel, by definig the dot as the decimal mark,but i don't want to do this, because i would have to do that in every computer that this file is runed...

So, does anyone know how to do this?

Thank you!

[royUK]

Is the TextBox on a UserForm? This works if it is

 Dim sText  As String
    sText = Me.TextBox1.Text
    sText = Replace(sText, ".", ",")
    Me.TextBox1.Text = sText

[mqdias]

Yes it's in a userform.

The textbox value is assumed as a "Double" variable, because it's suposed to be a number...

I don't know if this changes your answer...

thanks