for a textbox, you use the controlsource

Private Sub Userform_Initialize()
Textbox1.ControlSource = "Sheet1!A1"
End Sub

Listbox2.Value = Listbox1.Value

--
Regards,
Tom Ogilvy


"javabeens" wrote
in message ...

I 'm relatively new to VB programming & My question was, how do you set
the control source or rowsource of a text box so that you can make it
display data.
I have a case where I am trying to display sub-totals from an excel
spreadsheet into a text-box on a User-form.
And is it possible to make a selection in one listbox and have a
corresponding selection highlighted in another listbox?
Any help would be appreciated, thanx.

javabeens :)


--
javabeens
------------------------------------------------------------------------
javabeens's Profile:
http://www.excelforum.com/member.php...o&userid=24099
View this thread: http://www.excelforum.com/showthread...hreadid=377066