I have a spreadsheet cell that I would like to restrict entries of:


m, M, f, F, only.
I have data validation set up for the cell listing those 4 entries.

When ever someone enters a name such as matthew or Mary, the auto correct will
change the m entry into matthew.

Turning off the "AutoCorrect" is NOT an option.
Is there another way of limiting entries into this cell for the 4 entries listed above

thanks for any help
Cardinal 32

Maybe this helps you? Not sure if thats exactly what you mean, since it restrict the program to only allow numbers. I can't even be called a beginner in vba, but I do have quite some experience with c++. I'm sure that you'll manage to Change the If Not Statement accordingly

http://stackoverflow.com/questions/2...ll-input-value