Capital Letters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 21 Jan 2006 19:47 GMT

I have a coloumn that I would like to have in all capital letters.
Even if the user enters all lowercase I would like the spreadsheet to
convert it to capital letters. Any Ideas?

Reply to this Message

JE McGimpsey - 21 Jan 2006 19:57 GMT

Take a look at the hundreds of articles in the archives on this topic:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

> I have a coloumn that I would like to have in all capital letters.
> Even if the user enters all lowercase I would like the spreadsheet to
> convert it to capital letters. Any Ideas?

Reply to this Message

Gord Dibben - 21 Jan 2006 23:43 GMT

Jason

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column <> 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Target.Column number to be your desired column.

Right-click on the sheet tab and "View Code"

Paste the above into that module.

Gord Dibben Excel MVP

>I have a coloumn that I would like to have in all capital letters.
>Even if the user enters all lowercase I would like the spreadsheet to
>convert it to capital letters. Any Ideas?

Gord Dibben MS Excel MVP

Reply to this Message