Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hi All I use this code to make all character entered in the range upper case : Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("B1:B26")) Is Nothing Then Target(1).Value = UCase(Target(1).Value) End If Application.EnableEvents = True End Sub I'd also like to restrict these letters to "W" , "L" or "D". Can someone help with amending the code so that only these letters can be entered? It would be best if no error message were generated , juts a blank cell when any other letter is entered. Grateful for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Restricting entry | Excel Worksheet Functions | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
Restricting data entry to A-Z a-z 0-9 | Excel Discussion (Misc queries) | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions |