Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate data but then change the entry to upper case
Hi,
Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep pressing shift or caps lock while entering data in these cells. Ephraim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate data but then change the entry to upper case
use workshhet.selection chage event code
activedcell.value=ucase(activecell.value) On Mar 20, 2:55*pm, Ephraim wrote: Hi, Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep pressing shift or caps lock while entering data in these cells. Ephraim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate data but then change the entry to upper case
DV
Allow: List Source: W,L Make sure In-cell dropdown is checked "Ephraim" wrote: Hi, Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep pressing shift or caps lock while entering data in these cells. Ephraim . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate data but then change the entry to upper case
On Mar 20, 11:06*am, Teethless mama
wrote: DV Allow: List Source: W,L Make sure In-cell dropdown is checked "Ephraim" wrote: Hi, Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep pressing shift or caps lock while entering data in these cells. Ephraim .- Hide quoted text - - Show quoted text - Unfortunately the cells are so close together that using a list with in-cell dropdown covers the cell next to it which slows data entry. I was hoping to find a solution that would allow the user to input either W,w,L or l and then convert the lower case to upper case automatically. W or w represents a Win and L or l represents a Loss. Because the lower case l may be confused with the number 1 I wish to keep everything in upper case. A win is worth one point and a loss get's zero points. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate data but then change the entry to upper case
Assuming column A for entry
Option Compare Text Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column 1 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False If Target.Value = "w" Or Target.Value = "l" Then Target.Formula = UCase(Target.Formula) Else: Target.Value = "try again" End If ErrHandler: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Sat, 20 Mar 2010 08:37:18 -0700 (PDT), Ephraim wrote: On Mar 20, 11:06*am, Teethless mama wrote: DV Allow: List Source: W,L Make sure In-cell dropdown is checked "Ephraim" wrote: Hi, Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep pressing shift or caps lock while entering data in these cells. Ephraim .- Hide quoted text - - Show quoted text - Unfortunately the cells are so close together that using a list with in-cell dropdown covers the cell next to it which slows data entry. I was hoping to find a solution that would allow the user to input either W,w,L or l and then convert the lower case to upper case automatically. W or w represents a Win and L or l represents a Loss. Because the lower case l may be confused with the number 1 I wish to keep everything in upper case. A win is worth one point and a loss get's zero points. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Upper case data entry | Excel Discussion (Misc queries) | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How to change cell data from all upper to title case | Excel Discussion (Misc queries) |