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



.