in the properties of the listbox you can link it to a cell. If the listbox
is on a userform, the control source property would need an entry like
Sheet1!C9

if the listbox is on a worksheet you would use the LinkedCell property with
a similar entry.

--
Regards,
Tom Ogilvy

"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