Display Php Phillipine currency in vba excel

Hi i have a userform with textbox as unitprice. in unitprice there are two choices to enter its either a dollar sign or Philippine Peso PhP sign. I put up a check box for $ and another one for peso. the dollar signed is working but for philippine peso it doesnt work. May I ask your help guys on how to do this in vba macro and also i would like to know if you have other approach.


below is my vba code:

Please Login or Register  to view this content.

This is the result when i entered a nuemric value in unit price when i click the peso checkbox. P0P#,##0.00. when i used the dollar sign and enter a value. the value cannot edit anymore. let say i enter 100 which i the actual value is 100.10. the 2 decimal i cannot enter anymore.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

h is used internally by Excel for hour symbol, so you must escape this character using escape symbol "\" (backslah), like this :

Please Login or Register  to view this content.

Regards