<div>
Thanks Brad. Tried both methods and they work great.<br />
Cheers<br />
Toco
</div>


Thanks Brad. Tried both methods and they work great.
Cheers
Toco

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am building an application in Excel VBA and have a user form (ufOrdersForm) with a text box control which holds an invoice number.<br />
<br />
When the user double-clicks the text box I want its value (an invoice number) to pass to another form (ufSalesForm) as follows......<br />
<br />
Private Sub teInvoiceNo1_DblClick(ByVa<wbr />l Cancel As MSForms.ReturnBoolean)<br />
<br />
&nbsp; &nbsp;Application.ScreenUpdating<wbr /> = False<br />
&nbsp; &nbsp;Unload Me<br />
&nbsp; &nbsp;ufSalesForm.Show<br />
&nbsp; &nbsp;Application.ScreenUpdating<wbr /> = True<br />
<br />
End Sub<br />
<br />
How do I pass the argument from the procedure above to the intended user form ?<br />
<br />
Thanks in anticipation ?<br />
Toco
</div>
</div>


Hi Experts,

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
   Unload Me
   ufSalesForm.Show
   Application.ScreenUpdating = True

End Sub

How do I pass the argument from the procedure above to the intended user form ?

Thanks in anticipation ?
Toco

How do I pass an argument to an Excel userform in VBA ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.