View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hazel hazel is offline
external usenet poster
 
Posts: 114
Default 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