How to Change Upper Lower Proper Case in Excel


In this tutorial, I will be share how to change the UPPER LOWER PROPER case in MS Excel. For You, I will be making a video on this topic purpose, Because you properly learning how to change the UPPER LOWER PROPER case.

VBA Code:-

Sub ConvertToUppercase()

   Dim ws As Object

   Dim LCell As Range

   Application.ScreenUpdating = False

   Application.Calculation = xlCalculationManual

   For Each ws In ActiveWorkbook.Sheets

      On Error Resume Next

      ws.Activate

      For Each LCell In Cells.SpecialCells(xlConstants, xlTextValues)

         LCell.Formula = UCase(LCell.Formula)

      Next

   Next ws

   Application.Calculation = xlCalculationAutomatic

   Application.ScreenUpdating = True

End Sub

Sub ConvertToLowercase()

   Dim ws As Object

   Dim LCell As Range

   Application.ScreenUpdating = False

   Application.Calculation = xlCalculationManual

   For Each ws In ActiveWorkbook.Sheets

      On Error Resume Next

      ws.Activate

      For Each LCell In Cells.SpecialCells(xlConstants, xlTextValues)

         LCell.Formula = LCase(LCell.Formula)

      Next

   Next ws

   Application.Calculation = xlCalculationAutomatic

   Application.ScreenUpdating = True

End Sub

Sub ConvertToPropercase()

   Dim ws As Object

   Dim LCell As Range

   Application.ScreenUpdating = False

   Application.Calculation = xlCalculationManual

   For Each ws In ActiveWorkbook.Sheets

      On Error Resume Next

      ws.Activate

      For Each LCell In Cells.SpecialCells(xlConstants, xlTextValues)

         LCell.Formula = Application.Proper(LCell.Formula)

      Next

   Next ws

   Application.Calculation = xlCalculationAutomatic

   Application.ScreenUpdating = True

End Sub

If you facing any problem please join our Facebook group and post your problem with a screenshot. Many expert purposes waiting you for help purpose our Facebook group.


0 responses on "How to Change Upper Lower Proper Case in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *

© 2020 Tanvir Academy. All rights reserved. DESIGN & DEVELOP BY ~ Soft IT Care
X