In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name validation2️⃣ Folder Path validation3️⃣ 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 Operator2️⃣ Case Statement3️⃣ 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? #vba#excel#validation