Language accents

[nah]

Hello.

I have a cell in an Excel worksheet that has a dropdown list for the user to
choose from. The list contains spanish names with accents (like the ~ in
CATALUÑA). I also have a Validation function that makes sure that only an
entry that is part of the list is placed into the cell. If I don't want to
use my mouse to select from the list, and would prefer to type in the entry,
how can I make Excel ignore the accents in the word (say I'm typing with an
english keyboard that doesn't have the Ñ). Right now, it doesn't let me type
in CATALUNA without the accent.

Any help would be appreciated. Thanks,

Nikolai.

 

[NickHK]

Nikolai,
You can type it on an English keyboard, Alt+0209. Your user would obviously
have to know this. you could a nearby list of common codes.
You can find all these code in the Character Map, which is part of Windows,
probably under the System tools menu.

NickHK