Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If the user inputs lower case y/n answer How do I convert automat.
In Excel I have a column which asks for a Y or N response. If the user
inputs y or n in lower case Can I have Excel convert it to Upper Case? |
#2
|
|||
|
|||
Use Data Validation to force user to input uppercase
But, Excel is not case sensitive so =IF(A1="Y", Dothis, Dothat) will give DoThis for A1 = Y or y best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jhg1226" wrote in message ... In Excel I have a column which asks for a Y or N response. If the user inputs y or n in lower case Can I have Excel convert it to Upper Case? |
#3
|
|||
|
|||
Right-click the sheet tab, go to View Code, and insert
the code below: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Column = 1 Then '1 = col. A, 2 = col. B, etc. If .Count = 1 Then If .Value = "y" Or .Value = "n" And _ .Value = LCase(.Value) Then Application.EnableEvents = False .Value = UCase(.Value) Application.EnableEvents = True End If End If End If End With End Sub ---- Press ALT+Q to return to XL. The code is set to evaluate entries in col. A (1). Change if necessary. HTH Jason Atlanta, GA -----Original Message----- In Excel I have a column which asks for a Y or N response. If the user inputs y or n in lower case Can I have Excel convert it to Upper Case? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |