View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.