Resolved Question: How to I set a Excel VBA label to update automatically?

I am using a label to to display a data from a cell on a userform.
It works when I use this:

Private Sub Label10_Click()
Label10.Caption = Cells(28, 1).Value
End Sub

but this only updates when I click on a Label. If I change the "Click" to "Change" it doesn't display the value at all.

Also some of these labels will display a dollar value, how to I format the label to show $ 0.00?
I tried to to this same thing with text boxes. It worked with the exception of when the form was updated it would remove the formulas from the cell on the worksheet.

Thanks
Thank you for the detailed explanation. One problem, when I click on the worksheet at the top the code is blank. There is not two combo boxes shown. Also the remaining code you gave me, does that need to be placed in the userform code or the worksheet code?