I have two columns e.g. - fruit, code
apples, 01
oranges 02
lemons 03
On my form the cell for apples is a validation list cell
and I would like the cell for the code to appear in
another cell automatically.

I like validation rather than a drop-down combo box
because the "box" isn't seen until the cursor is in that
cell and doesn't print.

Can both cells be validation with the proper function in
the appropriate cell?