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

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

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

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