referencing values in adjacent cells to selected cell

  • Thread starter Thread starter Darren Haslett
  • Start date Start date
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
 
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)
 
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
 
Back
Top