how do i change the words from lower case to uppercase/capitals
Hi,
To do it as you type and to prevent any formula you type being converted to
values try this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
Target.Formula = UCase(Target.Formula)
End Sub
Mike
"dm" wrote:
I'd like to know the short cut keys to change the words I type from small
letters/lowercase to capital letters/uppercase.
|