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

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.

Regards
Nico

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

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


--
Regards
Frank Kabel
Frankfurt, Germany

Nico Le Roux wrote:
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.

Regards
Nico

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

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


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

Regards
Nico



.

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

Thanks Patrick it works. Saved me a lot of time.

"Patrick Molloy" wrote in message
...
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


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

Regards
Nico



.