MartyConnelly
martyconnelly at shaw.ca
Fri Sep 22 12:54:08 CDT 2006
Passing a parameter in a call is passed ByRef as default otherwise need to specify ByVal . Computer languages differ on this default. Function testA(ctlR As Control, ByVal ctlV As Control, _ strR As TextBox, ByVal strV As TextBox) As Long 'control is combobox Debug.Print ctlR.Column(0) Debug.Print ctlV.Column(0) 'Textbox needs focus strV.SetFocus Debug.Print strV.Text strR.SetFocus Debug.Print strR.Text End Function Martin Reid wrote: >I need to pass a text control on a form to a procedure byval as opposed to byref as byref errors out. How can I pass this to the procedure byval? > >Martin > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.405 / Virus Database: 268.12.6/453 - Release Date: 20/09/2006 > > -- Marty Connelly Victoria, B.C. Canada