Listbox on click
 

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

Listbox on click
 

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

Listbox on click
 

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