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.