Change Text Case in Excel using VBA /Macro | Multiple Columns in 1 click

In this video, we will learn the methods for converting text to Upper Case, Lower Case, or Proper Case in Excel using a VBA [Visual Basic for Applications] Macro.
This will help us to change the text of multiple columns and you would not need any additional columns as required in the case of formulas.

Download the excel file used in the video on the below link.

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section

Excel: Check this playlist for Excel-related things

Keyboard Shortcuts: Check this section to save some time in everyday excel work

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports

Power Query: Check the Power Query playlist for Data Preparation & its Automation

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations

Please subscribe to our channel and Follow us on other social media platforms for regular updates :

[pradipkar]

Sir, your tutorial has helped me in many different ways. But I want to know one thing that when we are writing the formulas in the cell then those formulas are visible or going in the formula bar. I want to write that formula(s) by VBA to solve the problem. How is it possible? If you give a detailed guide, it will be very helpful. For example, I am doing Date of Retirement calculation with EOMONTH or I am writing a specific formula in a cell to calculate Present Age. I want to run these formula in VBA. How to do? That means, I will write Date of Birth in one cell and Present Age in a cell and Retirement Date will be written in another cell simultaneously/automatically.