#1
|
|||
|
|||
Restrict Cell Entry
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 |
#2
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restrict data validation based upon a cell value | Strategic | Excel | 2 | 01-27-2015 02:13 AM |
Restricting Cell Entry to "N12345678" | balbas662 | Excel | 3 | 11-27-2014 12:46 PM |
Restrict access to content? | Zeratul | Word | 2 | 09-05-2014 05:40 AM |
To restrict the Accumlate Sum | MamaMonster | Excel | 2 | 03-16-2014 01:49 AM |
Trying to update a table cell with a value based on a drop down box entry | mkasem | Word VBA | 2 | 09-29-2013 08:36 PM |