Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation for state abbreviations
How can I set up data validation so that state abbreviations are entered as
two upper case characters? I have the abbreviations validated from a list, but it doesn't force all uppercase. Dick King |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation for state abbreviations
hmmm.
I tried creating a dummy validation (aka, not a complete listing of state abbreviations) and mine worked just fine. I pointed the validation to the list I created (which were entered as CAPS) and therefore my drop down list for the validation cell was populated with all caps. I tried overwriting the cell with just lowercase inputs and I got the expected error message. Did you make your list in all caps? -- Just a fellow Excel user here to help when I can..... "k1ngr" wrote: How can I set up data validation so that state abbreviations are entered as two upper case characters? I have the abbreviations validated from a list, but it doesn't force all uppercase. Dick King |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation for state abbreviations
This event code will change the entries to Upper Case when selected from the DV
list. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub Right-click on the sheet tab and "View Code". Adjust the "A1" to your DV cell address. If more than one cell has DV list alter to Me.Range("A1, B21, C13, D1") Copy/paste into that sheet module. Alt + q to return to the Excel sheet window. Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:11:02 -0800, k1ngr wrote: How can I set up data validation so that state abbreviations are entered as two upper case characters? I have the abbreviations validated from a list, but it doesn't force all uppercase. Dick King |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert State abbreviations color coded cell | Excel Worksheet Functions | |||
state abbreviations | New Users to Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
create a list box in one cell of state abbreviations | Excel Worksheet Functions | |||
US State Abbreviations List | New Users to Excel |