| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box to a Cell
Hi
I have a listbox with 20 columns per row, what code would I need to select a cell, every time I click on members name in the list box I would like it to choose the activeCell on the sheet ("Members") the cell would always be in Column "I" i.e. Lb1.List(, 8) - I can then find and change the date easily - with 600 members it is so time consuming scrolling down the list. -- Many thanks hazel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
| Change Combobox list to list more than 1 cell.value | Excel Programming | |||
| change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
| Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
Hybrid Mode
