View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allen Geddes Allen Geddes is offline
external usenet poster
 
Posts: 22
Default Currency Format for label in UserForm

I'm trying to apply the currency format to a label in a UserForm with the
following code:

Private Sub UserForm_Initialize()

Me.lblBudget.Value = FormatCurrency(Me.lblBudget, "#,###,###.00")

End Sub

But every time I try to run it, I get an error that leads to the ".Value"
after lbl.budget. Should I be doing this another way? Thanks for your help!!

-Allen