Changing CAPS to normal and vice-versa

D

Deepak

Hi

Please help me changing a cell's format from CAPS to normal and normal to
CAPS using keyboard combinations.

thanks
 
F

Frank Kabel

Hi
there's no such command. Excel does not support this kind of formating
(like Word does)
 
J

JE McGimpsey

Depends on what "normal" is to you. If you mean lower case, here's one
way:

Attach this to any keyboard shortcut:

Public Sub ToggleCase()
Dim rArea As Range
Dim rCell As Range
Dim sUpper As String
For Each rArea In Selection
For Each rCell In rArea
With rCell
sUpper = UCase(.Text)
If .Text = sUpper Then
.Value = LCase(sUpper)
Else
.Value = sUpper
End If
End With
Next rCell
Next rArea
End Sub
 
Top