In VBA we need to check if a character is valid or not. So, let me give some examples:
1️⃣ File Name validation
2️⃣ Folder Path validation
3️⃣ Date stored as text validation.
and this list can go on and on.
We can use loop and conditional statements to handle them.
Mostly I use.
1️⃣ Like Operator
2️⃣ Case Statement
3️⃣ String Method using Instr function.
In this video, I have explained all three methods with real examples.
Video is an easy way to explain this topic. Here is the video
How do you do validation checks?
