Userform Textbox Exit Event to Run Application

Originally Posted by baisty182

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!!

Application.Run is not a value to be assigned, hence no =, and the parameter is a quotes enclosed string containing the procedure name.

But as pointed out, Application.Run is superfluous.

Perfect thanks!!