Capital letters in a cell

[Guest]

Is there a way to set a cell so that when you enter letters they are always in capital letter form?

 

[AJ]

I don't know.
However, if there isn't a way then you could always just use the =UPPER() formula on the cells after they've been entered.

Hope this helps.

 

[Steve Hartman]

You can use data validation to restrict the entry to upper case. This would not allow the user to enter a value until it was in upper case.

You can also input your own error message that tells them what to do.
This message was edited by Steve Hartman on 2002-03-05 07:57

 

[Marc]

You can modify this. Regards, Marc

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Target is an argument which refers to the range being changed
If Target.Column = 3 Then
'this check is to prevent the procedure from repeatedly calling itself
If Not (Target.Text = UCase(Target.Text)) Then
Target = UCase(Target.Text)
End If
End If
End Sub