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

This Excel VBA Tutorial explains how to change Text to Uppercase, Lowercase or Propercase. Changing Case in Excel using VBA is easy, fast and timesaving.

[@mammothadventureracing]

This guy also finds the simplest and least lines to perform the VBA task. Love it!

[@diedrajohnson3066]

You make this feel so easy and uncomplicated!!!! Thank you!!!!

[@joeyruiz6777]

Easy to follow thank you

[@jlcourtman]

Excellent - thank you for this excellent tutorial!

[@birasafabrice]

thank you for this tutorial

[@ExcelDestination]

Welcome

[@cleubercunha]

Very good. Thanks

[@vijaysahal4556]

nice sir yours teaching way gud nd your coading simple but good

[@ExcelDestination]

Thank you!

[@saritas485]

If we want to apply the same in multiple sheets ??

[@ExcelDestination]

yes, you can

[@sayeedjamadar7045]

Sir good morning I need while typing in any case the text should convert to capital case plz suggest me

[@ExcelDestination]

This can be done with some additional VBA Code. Pls share your requirement at [e-mail]

[@LearnWithAmical]

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

[@gaspumprepairservice7009]

Turn on CAP LOCK?

[@archanaaa2514]

Sir what is private n public in coding parts. What is d use of writing private sub routine? When to use private sub routine n normal sub routine?

[@ExcelDestination]

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.

[@archanaaa2514]

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

[@boughararahedi4515]

Think you ...but this work on Excel version Premium...

[@prakashbehera4390]

How to change without vpa code

[@saritas485]

Got run time error 13

[@ExcelDestination]

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