combo box
 

i want to do the following using one combo box: this box
has 3 columns.....the row source is called 'apple', the
second column, for example, is what the user sees(i.e.
selects from the 'apple' data range).....

what i'd like to have happen is when the user selects
from the drop down list(i.e column 2 in apple).....the
corresponding info in column 1 is placed in cell 'A1'(of
worksheet1)....and the corresponding info in column 3 is
place in cell A3(of worksheet1)....this is to be done in
the background so column 2 is the only one the user
sees......

i've done this for one column(the bound column)...placing
the value in the cell.....but i'm not sure how to
manupulate the column properties or whatever for 2
cells.....

thanks in advance for your help.......dxxy