Data Validation
Hi,
I have several columns of cells that I have data validation on so people do not input data incorrectly. However the data validation still allows people to input nj when I want it to be NJ (caps). Is there anyway to force data validation to recognize caps vs. lowercase. Thanks in advance. Aaron |
Data Validation
Hi
use the formula EXACT to check for uppercase. e.g. for cell A1 =EXACT(A1,UPPER(A1)) this allows only uppercase entries -- Regards Frank Kabel Frankfurt, Germany Aaron wrote: Hi, I have several columns of cells that I have data validation on so people do not input data incorrectly. However the data validation still allows people to input nj when I want it to be NJ (caps). Is there anyway to force data validation to recognize caps vs. lowercase. Thanks in advance. Aaron |
Data Validation
Hi Aaron,
One way would be to put the following code into the code module of the appropriate sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("DataInput")) Is Nothing Then Target.Value = UCase$(Target.Value) End If End Sub Obviously change to the name of the data range to whatever you are using. HTH Peter Beach "Aaron" wrote in message ... Hi, I have several columns of cells that I have data validation on so people do not input data incorrectly. However the data validation still allows people to input nj when I want it to be NJ (caps). Is there anyway to force data validation to recognize caps vs. lowercase. Thanks in advance. Aaron |
Data Validation
If there's a short list of options, type it in the Data Validation
dialog box, instead of referring to a range on the worksheet. Using a delimited list will make the data validation case sensitive. Aaron wrote: I have several columns of cells that I have data validation on so people do not input data incorrectly. However the data validation still allows people to input nj when I want it to be NJ (caps). Is there anyway to force data validation to recognize caps vs. lowercase. Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 05:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com