referencing values in adjacent cells to selected cell

D

Darren Haslett

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
 
B

Bob Phillips

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)
 
A

Alan Beban

Bob said:
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.
Click to expand...

Or ActiveCell(n+1, m+1)

Alan Beban
 
Top