| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| capture listbox click | New Users to Excel | |||
| ListBox Click Event | Excel Discussion (Misc queries) | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Threaded Mode
