VBA to Change Text to Uppercase, Lowercase or Propercase - Excel VBA Example 

Welcome

Thank you!

yes, you can

Private and Public are Object Oriented Programming's concept. Private declaration works within same class and public declaration can allow use of object outside the class or by different class.

@@ExcelDestination sir how to do redo in vba code? If something is deleted in excel sheet?

This can be done with some additional VBA Code. Pls share your requirement at exceldestination@gmail.com

Private Sub Worksheet_Change(ByVal Target As Range) If Target.HasFormula Then Exit Sub Application.EnableEvents = False Target = UCase(Target.Cells(1)) Application.EnableEvents = True End Sub

Turn on CAP LOCK?

ok...........check your code