Changing CAPS to normal and vice-versa

[Deepak]

Hi

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

thanks

 

[Frank Kabel]

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

 

[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

 

[wiseman]

Deepak,
If you are prepared to use a menu to do this then changing caps to lower
case or vice versa is one of the useful parts of the ASAP addin
http://www.asap-utilities.com/
(it is in the text part of the ASAP menu)
Barbara