Help with thousand and decimal separators

[Rockinfreakapottamus]

Hi, i'm having trouble with values in a textbox.
I have multiple textboxes that i need to enter/display currency values like the following for example: $100,000.00 I managed to enter/display only the comma separator for thousand, million, etc, but i cant find a way to enter/display the decimal separator (dot), the code i use for the comma separator and $ is the following:

    TextBox1.Value = Format(TextBox1.Value, "$###,##")

Can anyone bring me some help with this?

 

[Colo]

Welcome to the board.
Something like this?

TextBox1.Value = Format(TextBox1.Value, "$#,##0.00")

 

[Rockinfreakapottamus]

Welcome to the board.
Something like this?

TextBox1.Value = Format(TextBox1.Value, "$#,##0.00")

Tried but it doesn't work like i imagined. To be more specific: in some textboxes i need to type values like "1,500.64" (for example), with

TextBox1.Value = Format(TextBox1.Value, "$#,##")

the code puts automatically the comma separator but i aint able to put the dot for the decimals.
The one you give me only increments from 1.00 no matter which number i put