Can't get a userform text box to display a number format, ie "Currency"

I am creating a userform that will take inputs and then calculate a number of different results. Some results will be in number format and other I would like currency(US) format. I have tried to format the controlsource cell and used this statement, my textbox in this example is txtBasePay. txtBasePay.Value = Format(txtBasePay.Value, Evaluate(txtBasePay.ControlSource).NumberFormat) but that hasn't worked. I have tried simple formatting code like txtBasePay = Format (BasePay, "Currency") without success.

Greg

Actually the above Sub should read txtBasePay.Value = Format(BasePay.Value, Evaluate(BasePay.ControlSource).NumberFormat)

Thank you Stnky, but the box does update correctly to a new value when I change input but the format is not shown.

I would like my text box to show "$10.00" instead of 10

I have attached a striped down version. The only textbox I have coded is BasePay. But I am going to need formatting for others as this will grow.

I have uploaded a workbook. I have been away from Excel for a little over two years and just getting back to it. I have used userforms before but never wanted to format the shown result in the textbox. For instance b4 has hours worked from userform input and b5 hourly pay from userform input and then a textbox that will show b4*b5 in currency.

The userform works. I need user input and have no idea how to code that. I just wanted to have number formatting.

A user would type in his or her hours worked in those text boxes. There is other input from users but it text based, ie name.

I am entering data into a user form. IE text box for name. hours worked, hourly pay rate, then the userform will return in other textboxes the pay, the whithholding ect. So for example the user inputs hours into taxtbox1 and pay rate in textbox 2 and in textbox 3 appears his pay. In textbox 3 I would like it to be formatted to currency. I also need other boxes to be fomatted in number with 2 decimal places. The user will not have access to the worksheet that the textbox controlsource is linked to.

Yes jaslake the downloaded xlsm does what I want. Thank you! Now I have a lot of code to write....

Originally Posted by jaslake

Hi Gwg1955

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

If you need further help let us know.

Can't figure that out on my phone, have to wait till tomorrow. Thanks again.