MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Bryan on August 11, 1999 2:16 PM


My goal is to use the offset command (I think) to do the following:

I have a listbox that lists the items in column A, and when I pick on to insert the value into any cell, I would like for the value of the adjacent cell of the one chosen to insert into the adjacent cell that I am filling.. can anyone give be a push?

Posted by Ivan Moala on August 12, 1999 2:53 AM

use the ListIndex Property to see which selection
you selected from the listbox, then do something
like select case in your routine to iterate through the options and criteria you want to do ie
for the click routine for the listbox
do an evaluation like;
case select listbox.index

case 1
do something
case 2
do something else
pobably have to use cell references together with
the actual index number to get the correct cell.