listbox value to a form
 

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

--
alexander
-----------------------------------------------------------------------
alexanderd's Profile: http://www.excelforum.com/member.php...nfo&userid=498
View this thread: http://www.excelforum.com/showthread.php?threadid=38783

listbox value to a form
 

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