Change TextBox format in UserForm

[Pegah.Omrani]

Hi,

How can I change Textbox format (in User Form) to Number with separator?

I have a user Form that user should enter $ value in text box, I do need to format them as a Number with Separators.

Thanks in advance.

Peggy

 

[Pegah.Omrani]

I found it!

With Me.txt

.Value = Format(.Value, "#,##0;-#,##0")

End With

 

[longchamponline]

Right-select the text box, and then "Format Text Box"--Solved.


Welcome to our the longchamp online shopping, in order for our products. Learn more invited to our official website: http://www.longchamptaschenschweiz.eu