Your previous post says you are using a form, so....
(helps to keep your posts together if they are the same topic)

Set the ControlSource to the cell where you want the input.

Or set the event code for the listbox
Range("A1") = Listbox1.Value

--
sb
"WiReLaD" wrote in message
...
Hi, Again!
How do I get the data from my listbox1 when I click on one of the items?

eg.
If my listbox opens with 5 options listed. if I click say the 2nd in the
list, I want that to transfer to my worksheet.

with thanks
WiReLaD