how should show number form in label on userform

[Alaa mg]

I have this code and I would show number format in label4 after select item from combobox1 ,but will shows error object required !

Format(Label4.Caption, "#,##0.00#") = Cells(lRow, 5).Value

!
how fix it,please?

Private Sub ComboBox1_Change()
If ComboBox1.ListIndex = -1 Then Exit Sub
If ComboBox1.Value <> "" Then
Dim lRow As Integer
lRow = Application.Match(ComboBox1.Value, Sheets("CUSS").Range("B:B"), 0)

Format(Label4.Caption, "#,##0.00#") = Cells(lRow, 5).Value
End If


End Sub

 

[Joe4]

I think you may need something like this:

Label4.Caption = Format(Cells(lRow, 5).Value,"#,##0.00#")

 

[Alaa mg]

Perfect !
many thanks buddy .

 

[Joe4]

You are welcome.

Just remember that anything you want to do (like apply the FORMAT function), has to be on the right side of the equation.
The left side is just the object you are applying it to (whether that be a variable, range, caption, etc).