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

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

Bob Phillips wrote:
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.

Or ActiveCell(n+1, m+1)

Alan Beban

Offset worksheet function does what you need to do.

-----Original Message-----
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


.