Data Validation

[Aaron]

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

 

[Frank Kabel]

Hi
use the formula EXACT to check for uppercase. e.g. for cell A1
=EXACT(A1,UPPER(A1))

this allows only uppercase entries

 

[Peter Beach]

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

 

[Debra Dalgleish]

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.