How do I reference the cell address next to Active cell - Try 2

  • Thread starter Thread starter Nico Le Roux
  • Start date Start date
N

Nico Le Roux

Frank & Tom help me with my previous request but unfortunately I have to
approach the obstacle from another angle.

My user choose something from the my combo box (2 columns of data displayed
in combo box - Number & Description) and the VBA code add the value from
BOUNDCOLUMN 1 to the active cell how can I add the value from COLUMN 2 into
the cell to the right of the active cell.

Your help would be appreciated.
 
Hi
to reference the cell right to the active cell try
ActiveCell.Offset(0,1).value = your value
 
the combos ListIndex Property points to the selected
values
with combobox
Target.Value = .List(.Listindex,0)
Target.Offset(0,1).Value = .List(.Listindex,1)
end with



Patrick Molloy
Microsoft Excel MVP
 
Thanks Patrick it works. Saved me a lot of time.

Patrick Molloy said:
the combos ListIndex Property points to the selected
values
with combobox
Target.Value = .List(.Listindex,0)
Target.Offset(0,1).Value = .List(.Listindex,1)
end with



Patrick Molloy
Microsoft Excel MVP
Click to expand...
 
Back
Top