This video will show you how to type or force data entries in uppercase or lowercase or proper case in Excel.
By learning this, one can allow entries in specific letter cases only thus preventing entries in another letter case.
I will show you two ways – using data validation and using VBA both having it pros and cons.

In this video you will learn or see
– How to use Excel data validation to force users to make an entry in a particular letter case.
– VBA to auto-change entries in particular letter case (auto-capitalize or auto small text input) when user entered or typed in the wrong letter case.
– How to make entry in uppercase in one column, lowercase & proper case in other columns using VBA.
– Also, know loopholes (pros and cons) of data validation method

Jump to a section
Using data validation method 0:37
Why use Exact function 1:27
Loopholes in data validation 5:19
Auto entry in particular letter case using VBA 6:03
Enabling event in excel 8:05

Click the below link to download the file.
https://drive.google.com/file/d/1LfPx7Dh4e1-5o6KRkOoamXLfuzLA7Swy/view?usp=sharing

Websites
https://learnyouandme.com
https://www.juggle.biz
Make your Digital Visiting Card https://mydvc.info/
Facebook https://www.facebook.com/LearnYouAndMe
Quora link https://www.quora.com/profile/Abhishek-Pandey-328

You can watch and learn from the below videos also.
Highlight active cell automatically without erasing past cell colour (Method-2)
https://youtu.be/xssQo3HdrhA

How to write formula/function in Excel in Hindi?
https://youtu.be/60u0m_81K9k

Ways to EDIT or MODIFY Excel formula
https://youtu.be/IadxOIrTp7k

Restrict Editable Range In Excel
https://youtu.be/7-xqaWM0N6o

How to apply and use filters EFFICIENTLY IN EXCEL.
https://youtu.be/mivXSU30jlY

Color VBA – part 3 (cell blinking or flashing effect)
https://youtu.be/uDTu9NwclLM

Shortcut key for subtotal formula (trick).
https://youtu.be/6s_IazvkAWc

VBA to auto get / insert image in excel cell (multiple images insertion and auto-resize in cell)
https://youtu.be/QkXDGztJCY0

Auto highlight active cell VBA.
https://youtu.be/qdxmo3-uS_o

Fastest vlookup formula (exact match type) .
https://youtu.be/qorwmdXGOC8

#learnyouandme
#autochange#text#case#excel
#ms#excel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.