Validation - automated in adjacent cell

D

Dianna

I have two columns - 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top