I am creating an order form which needs to have a drop down lists so they can only select the correct ones. I have created the drop down lists and got that to link to a cell which work but it exports the position number not the value they selected. I have sucessfully done this using the active x controls but i didnt want to use them as some version block them and they can be a pain.
Is it possible to use the form control drop down menus to export the value:
Ie RED then it exports that to the linked cell as RED.
I need to do this so when the form comes back we can automatically import the flat excel file into Access. So that why I need to link it to a cell on a new hidden sheet.