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

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.
 
F

Frank Kabel

Hi
to reference the cell right to the active cell try
ActiveCell.Offset(0,1).value = your value
 
P

Patrick Molloy

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
 
N

Nico Le Roux

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...
 
Top