VBA newbie here.
I am creating a spreadsheet in excel that will be imported into an Access database later on. I am getting users to select a value from multiple drop down menus. My problem is, these drop down menu values need to be very specific, and are not very readable, for example:
notAttendingSchoolWhy: (choose one)
TOO_YOUNG_FOR_SCHOOL GRADUATED NOT_ATTENDING_DUE_TO_DIABETES NOT_ATTENDING_DUE_TO_FINANCIAL_REASONS NOT_ATTENDING_FOR_OTHER
I'd like these to be a bit more readable, but still be able to be imported into my database. So, I'd like to use something like an alias in excel where the user sees the 'nice' version, e.g.
not Attending School Why: Too young for school Graduated etc.etc.
and I can still put the matching version into my database.
any ideas? All help much appreciated!!
Aucun commentaire:
Enregistrer un commentaire