Auto Formatting a cell to change text to all CAPS.

You won't do this via formatting but some simple code would work. Paste the following into the relevant sheet module:

Thanks njimack,

One question...how do i access the sheet module? Is it a macro or VBA? I tried using a macro but I'm not completely competent with macros.

Thanks, Eric.

Access the sheet module by Right_Clicking the sheet tab and choosing "View Code"

lenze

Exactly what I needed, except for one thing...

I get a Microsoft Visual Basic error when ever I delete something from a cell:

Run-time error '13':

Type mismatch

With the options to 'End' 'Debug' 'Help'

When I click Debug it highlights in yellow the following part of your code:

Private Sub Worksheet_Change(ByVal Target As Range)
-->Target.Value = UCase(Target.Value)
End Sub

How can I fix this?


Thanks, Eric.

Oops!

Try this:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo 0
Target.Value = UCase(Target.Value)
End Sub

Nope, same error.

It's still getting a type mismatch error.

It's pointing to this part of your code:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo 0
-->Target.Value = UCase(Target.Value)
End Sub

There are some formulas on the sheet, does that make a difference?

OK, 3rd time lucky. This code tests whether the target cell contains a formula. It also tests that only one cell is selected.

Your excel fu is VERY strong young njimack!!!

Works like a champ!

I will apologize in advance for my complete lack of Excel knowledge when asking this question. I am trying to change everything in my sheet to uppercase letters. I did like one of the previous posts said and entered the code but I got this response:

The following features cannot be saved in macro-free workbooks:
-VB project
To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.
To continue saving as a macro-free workbook, click Yes.

Can someone please advise me here?

I came into an already established Access database imported from our retail system which we also have a branch of Excel for email addresses. The jist, is that for USPS purposes, everything needs to be in uppercase letters. There are hundreds upon hundreds of entries in the Excel file that are not uppercase.

Thanks!!