This should be an easy one...
In a specified range of cells, I want for any characters (alpha) typed in those cells to show up as uppercase regardless of how they're typed (and no, CAPS LOCK is not the way I want to go!)
Thanks!
This should be an easy one...
In a specified range of cells, I want for any characters (alpha) typed in those cells to show up as uppercase regardless of how they're typed (and no, CAPS LOCK is not the way I want to go!)
Thanks!
Nevermind! Found it in a search here...
Josiah,
Please read forum rules below. All code must be wrapped as per rule 5
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Oops! Sorry! (I was wondering why that disappeared! )Originally Posted by VBA Noob
FYI -
For those who may be looking for this answer too, here's the code I used:
Private Sub Worksheet_Change(ByVal Target As Range) '''''''''''''''''''''''''''''''''''''''''''' 'Forces text to UPPER case for the range A1:B20 '''''''''''''''''''''''''''''''''''''''''''' If Target.Cells.Count > 1 Or Target.HasFormula Then Exit Sub On Error Resume Next If Not Intersect(Target, Range("A1:B20")) Is Nothing Then Application.EnableEvents = False Target = UCase(Target) Application.EnableEvents = True End If On Error GoTo 0 End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks