EXCEL ME CASE CHANGE KEY BANAO BY COADING

Kya Apko Pata He Excel Pe Case Change Karne Ka Koi Option Nahi Hota To Hum  Press Key Bana Sakte Hai Excel Me Jo Automatic Hi Case Change Karega Aiye Pahle Dekh Lete He Kuch Example Chal

Sub upper()

For Each cell In Selection

If Not cell.HasFormula Then

cell.Value = UCase(cell.Value)

End If

Next cell

End Sub

Sub proper()

For Each cell In Selection

If Not cell.HasFormula Then

cell.Value = Application.WorksheetFunction.proper(cell.Value)

End If

Next cell

End Sub

Sub lower()

For Each cell In Selection

If Not cell.HasFormula Then

cell.Value = LCase(cell.Value)

End If

Next cell

End Sub