Hi,
Why do I get a type mismatch error when this works:
but this doesnt:![]()
Private Sub UserForm_Initialize() Me.lblNAVPS.Caption = Format(Worksheets("summary").Range("L11").Value, "$#0.00") End Sub
That is, the form initializes the values ok, but then when I add the code to calculate I get the type mismatch?![]()
Private Sub Worksheet_Calculate() frmPanel.lblNAVPS.Caption = Format(Worksheets("summary").Range("L11").Value, "$#0.00") End Sub
Any thoughts?
Thanks!
Bookmarks