I have this code that should update textPERC everytime i exit another Textbox...
Sub TextMOTid_exit(ByVal Cancel As MSForms.ReturnBoolean)
Application.Run = percupdate()
End Sub
Sub percupdate()
'UserFORM Percentage
With textPERC
'Set the text of the label.
textPERC.Caption = Format(expression:=Sheet1.Range("A3"), Format:="0.00%")
'Automatically size the label control.
.AutoSize = True
.WordWrap = False
'Set the font used by the Label control.
.Font.Name = "Tahoma"
End With
End Sub
However on exit i get the following error...
'Compile Error:
Expected Function or Variable'
Probably something simple!!
Bookmarks