auto correct small leters to caps letters

  • Thread starter Thread starter Santhosh
  • Start date Start date
Your function is: UPPER
You may use it in an adjacent sheet to achieve what you want OR to run a
macro on all the used-cells in your sheen to change the appropriate letters.
Micky
 
Forgot the Macro:
----------------------------------------------------------------
Sub MakeAllLettersUppercase()
For Each CL In Selection
CL.Value = UCase(CL)
Next
End Sub
 
Hi Santhosh

If you are looking for Autocorrect then try the below. Select the sheet tab
which you want to work with. Right click the sheet tab and click on 'View
Code'. This will launch VBE. Paste the below code to the right blank portion.
Get back to to workbook and try out.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.HasFormula Then Target.Value = UCase(Target.Value)
End Sub
 
Micky

Be careful with that macro.

If any formulas in the selected range, your code will change them to values
only.

I suggest this revision.

Sub MakeAllLettersUppercase()
For Each CL In Selection
CL.Formula = UCase(CL.Formula)
Next
End Sub


Gord Dibben MS Excel MVP
 
Back
Top