uPPER cASE

[Ampleford]

This is probably very easy to you guys

how do I format cells so that when letters are keyed in - they automatically go into upper case......


)

[Ricky Morris]

I think you would need to use VBA to accomplish that. Right click on the sheet tab, click View Code and enter the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("a1").Value = UCase(Range("a1").Value)
End Sub

Where A1 is the cell you would like to capitalize.

[Al Chara]

You can put the following code in the Worksheet declarations:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target <> "" Then Target = UCase(Target)
End Sub

This will work for all cells on the worksheet.

[Ampleford]

Thanks

trevor