One of many ways is to just create a variable

Dim tbox1 as String

tbox1 = Userform1.Textbox1.Value


than do what ever you want with tbox1

--
steveB

Remove "AYN" from email to respond
"harryward27"
wrote in message
...

Thank you for your replies.

I wanted not to put anything in any cells but I have changed tac on
the project.

I still would like to know if it is possible to link to listbox without
putting any thing in a cell.

Cheers :)


--
harryward27
------------------------------------------------------------------------
harryward27's Profile:
http://www.excelforum.com/member.php...o&userid=25499
View this thread: http://www.excelforum.com/showthread...hreadid=389501