In the form activate value, assuming to a textbox, something like

Textbox1.Text = Worksheets("Sheet1").Listbox1.Value

--
HTH

Bob Phillips

"alexanderd" wrote
in message ...

i have an excel form and list box, how can one copy a line from a list
box to a user form


--
alexanderd
------------------------------------------------------------------------
alexanderd's Profile:
http://www.excelforum.com/member.php...fo&userid=4984
View this thread: http://www.excelforum.com/showthread...hreadid=387838