Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |