Jan, 11, 2021
So today's learning is very informative and specific to those who have some basic or advance knowledge about Excel Macros and VBA.
In each training, participants ask when to use what and are there any specific situation and a way out to understand the topics. Well, my answer is YES.
One of the common questions is, what is “Option Explicit”?
So let me explain to you that it’s a code that we type on top of the module and out of any procedure (Sub/Function). The purpose is to check and force variable declaration.
Example wise benefit is to catch if there is any mistake in a variable name or not? so it will be immediately trapped before running procedure. Let's say you have declared a variable as EmpDepartment and after assigning a value in this variable in a procedure while executing the procedure, you by mistakenly typed EmpDpartment then it will catch it and return compile error rather than giving no output in runtime. So that’s it for the day and keep reading.
Do you want to know more? Are you willing to learn beyond limitations? Contact now
Altaf Karimi – Coach, Trainer and Healer – 9702823999
#AltafKarimi #VokksenAltaf #TheYoungistaan #Excel #PowerPoint #Macros #VBA #PowerBI #SQL #Learn #Teach #Training #Kids #Adult #CorporateTraining #CollegeTraining #SchoolTraining #Corporate #College #School #Teenagers #Advance #India #Education #Productivity #Grow #Earn #vctak #ytnkids #Trainer #Tutors #Educationist #Coach #India #Initiative #SeekhoIndia #Seekho #Brain #Habits #Behaviour #IT #SoftSkills #DMIT #Healing #Therapy #Change
comments (00)