Thread: 'currency format' and formula question in vba excel 2010

i have the following for my userform:

one text box is txtbaserate,
the other text box is txtannualsal.

my base rate text box is not showing $00.00. It's showing $0.00.
here is my code.

Private Sub txtbaserate_change()
      txtbaserate.Text = Format(txtbaserate.Text, "$#,##0.00")
End Sub

My other question is how do I show a calculation to get an annual salary in my other text box?

=txtbaserate*40*52?

I must be clueless!!!!
thank you!

Is this homework? Those variable names have to be in just about every coding textbook I've ever read.

Do some searching on "vba format numbers" and see if you can figure out the difference between # and 0 in the format expression.

As for determining the salary, you already have the textbox change code for when you change the value in txtbaserate, so you just need to add the mathematical function you stated and assign that value to txtannualsal.