Capitals in Excel

[nfpk]

I know that there is a function in Excel which makes capitals of lower-case letters.
But can you format the cell so that it gives you capitals at once? Like you can in Access...

nfpk

 

[mudstuffin]

Hello Nfpk.

This may do what you are trying to achieve....


Private Sub Worksheet_Change(ByVal Target As Range)

On Error Resume Next
Target = UCase(Target)

End Sub


This will change the the cell to uppercase once it has been typed in.

Regards,


mudstuffin

 

[Edrondol]

If you need to do this in the entire sheet, change the sheet font to something like Conga, which is all caps anyway.


-Dave

Any dog is just a dog. But if he has you
by the butt he's MR. Dog!