Textbox Currency Format

[Sebastiandiaz]

Hello, I have a question, I know that to provide de currency format to a textbox I can do it by using this:
TextBox1.Value = Format(TextBox1.Value, "$###,##")
But can I make it to have another country currency, for example Costa Rica currency? The curency for this country is colones ₡ , Is the a way to change it to this currency?

 

[Belleke]

Like this?
enter ammount without currency symbol and push test.

 

[Sebastiandiaz]

It is amazing, but how can I do to add decimals?

 

[Sebastiandiaz]

Is it possible to display de currnecy format when typing on the textbox? something like in the image bellow.

 

[Marc L]

Yes, just add the symbol when the textbox is empty …​

​

 

[Belleke]

Like this, enter the ammount without currencysymbol en press enter or tab

 

[Belleke]

, just add the symbol when the textbox is empty …

Show how ,you are still living in la la land

 

[Sebastiandiaz]

YES.... THANK YOU SO MUCH.

 

[Belleke]

Glad to help., an.d thanks for the feed back

 

[Marc L]

Show how ,you are still living in la la land

At beginner level, easy for you … Or just format the textbox each time a key is pressed.​

​