On 2002-07-24 13:19, Rick M wrote:
How do I Format a cell to either change any text to CAPS or require the User to input in CAPS?
Thanks.
If you want to do this with VB code paste the following in to worsheet VB section. This will capitalize in cells A1 to D10
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1:D10")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub
Dave