How do I pass an argument to an Excel userform in VBA ?
Posted on 2013-11-02
I am building an application in Excel VBA and have a user form (ufOrdersForm) with a text box control which holds an invoice number.
When the user double-clicks the text box I want its value (an invoice number) to pass to another form (ufSalesForm) as follows......
Private Sub teInvoiceNo1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Application.ScreenUpdating = False
Application.ScreenUpdating = True
How do I pass the argument from the procedure above to the intended user form ?
Thanks in anticipation ?