043-VBA Implicit and Explicit Declaration

043-VBA Implicit and Explicit Declaration

In this video, I am explaining about the VBA Implicit and Explicit variable declaration options. These 2 options help us to declare variable statically and dynamically. As a beginner, it’s important to understand both options to make program error free and more robust.
OPTION EXPLICIT - An explicit declaration statically types the variable it declares. In a language that requires explicit declaration, you will get a compilation error for any reference to a variable that has not been explicitly declared.
Example – Dim x As Integer
x = 10
OPTION IMPLICIT – Opposite to Explicit. Dynamic but error prone at compilation.
Example – x = 10

Below are few links for more better understanding: -
https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/option-explicit-statement




About VBA Automation Course: -
This VBA Automation course is series of videos where I am explaining each and every point to start with beginning to become expert in Automation / Coding / Programming.
This course will definitely help those who are struggling with day to day repetitive work.

Using Automation, we can simply eliminate such boring and manual tasks from our daily life and become more productive and efficient in organization or normal life.

Automation is today's industry demand and can help to get more package and reputation than before.

We can take any industry for example, but I am specific to IT and related services.

With Automation, one can simply achieve more productivity than before.

Having said that, let's start our journey towards Automation.