In a convenient empty column in the workbook, preferably out of site eg a
hiddeen worksheet, enter all 77 County names (laborious I know). Name this
range 'county' or whatever and in your input field go Data Validation,
choose 'List' and in the dialogue box below enter
=county
Enter a suitable error message and that's it done.
Changing the case of inputted data can be done with VBA code, but not by
formatting, suggest you ask this in Programming,
Regards,
"barryderay" wrote in message
...
I have a field asking for a county name. There are 77 possible counties to
enter. I want to ensure that the user enters a valid county and has it
spelt
correctly. Is there a way to do this? Can I have the validation point to
text
file with all the acceptable entries? Also is there a way to format the
cell
to convert anything entered into all upper case?