VBA code to check date, currency, number in userform textbox (TextBox Event ) Part 2

[@nareshkumar9647]

Thanks for a very useful video. I used the code for formatting currency. But I had a problem using it. First I check if there is a number in the text box of the user form. If not, I fill the required number and press enter. The number is formatted in the text box, say it changes from “123” to “123.00”. But when I add it to the cell of worksheet, it shows as “123”. The decimal and two zeros do not show. Please advise the resolution to this problem.

[@vbaautomationtutorialpoint5315]

Please change the format of the cell in Excel sheet as well

[@nareshkumar9647]

@@vbaautomationtutorialpoint5315 Thanks a lot for your reply.