Listbox on click

[WiReLaD]

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

 

[steve]

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

 

[Tom Ogilvy]

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.