Darren,

First part.

ActiveCell.Offset(n,m)

where n refers to the number of rows to offset (0 is same row), and m is the
number of columns. Both n and m vcan be negative to allow for rows/columns
before.

Second part.

I would suggrest popping up a userform with a listbox, shich can be linked
to the cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Darren Haslett" wrote in message
u...
Hi gurus,

When a certain cell is selected, I want to access the values in the same
row, but a couple of columns to the left of the selected cell for
inclusion
in a list box. Also, how can I create a list box on the fly using these
values that the user can select from to input into the selected cell? Any
info would be appreciated.

Thanks

DJH