Prev: Connect.UpdateToolbars?
Next: how to reveal formatting
From: Looping through on 18 May 2010 11:27
Is there a way to force all cap text within a cell even if the user does not
have their cap lock on their computer?
From: Stephen C on 18 May 2010 11:38
Try the following worksheet change event, remember to change A1 to suit
your worksheet.

Private Sub Worksheet_Change(ByVal target As Range)
If Not Application.Intersect(target, Range("A1")) Is Nothing Then
Application.EnableEvents = False
target.Value = UCase(target.Value)
Application.EnableEvents = True
End If
End Sub


"Looping through" wrote:

> Is there a way to force all cap text within a cell even if the user does not
> have their cap lock on their computer?
 | 
Pages: 1
Prev: Connect.UpdateToolbars?
Next: how to reveal formatting