PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

USE IF THEN ELSE IN VBA

INTRODUCTION

In our last lesson, we learnt about different loops. How to program and use the loops.

Let us now see one of the most important constructs of any programming language which is IF THEN statement.

There is nothing in this world which is without the conditions. So , this effect also comes in when we are going to program for any problem. We can’t let the control go out of control or do whatever it want, so is the need of Control controlling conditional statements.

One of the most important controlling statement is IF THEN  in VBA which is going to be used extensively.

In this article we’ll understand when and how we can use this statement with the help of few examples.

 

 

SYNTAX OF IF THEN CONSTRUCT

SYNTAX is a particular way of writing the programs.

Here is the syntax of IF THEN CONSTRUCT

IF condition THEN Instructions                                  [IF CONDITION IS TRUE ]

ELSEIF Instructions                                                     [ ANOTHER CONDITION]-OPTIONAL

ELSE Instruction                                                          [IF CONDITION IS WRONG]-OPTIONAL

END IF                                                                            [ENDING THE IF]

IF THEN ELSE construct
starts with the IF instruction followed by the CONDITION which we want to decide.
After condition comes the keyword THEN after which comes the instructions which should be executed
if the condition is true.
There are few optional keywords also.
IF WE WANT TO CHECK MORE THAN ONE CONDITION MAKE USE OF ELSEIF.
For the NON APPLICABILITY of the given condition make use of ELSE which will have the instructions to be executed if the condition is not true.
If is ended by END IF.
*If it doesn’t have many instructions there is not need of END IF.
 

EXAMPLE 1-IF THEN ELSE IN VBA

Starting with a simple IF example.

We’ll mention a date and check if the date matches with today’s date or not.

CODE

‘GYANKOSH.NET IF THEN ELSE CONSTRUCT EXAMPLES
‘SIMPLE IF

Sub IfExample1()

Dim today As Date

today = “14/04/2020”

If Date = today Then MsgBox (“Hello Everyone. I have successfully checked the date and the date is ” & Date)

End Sub

EXPLANATION

The code starts with the declarations of the sub procedure.
An object named today is created with the type DATE.
today has been passed on the value =”14/04/2020″
If statement starts and the condition is checked if the date today is same as Date( it returns today’s date) . If yes a message will be shown.
The sub procedure is ended.

RUNNING THE CODE AND OUTPUT

IF THEN EXAMPLE IN VBA
VBA -IF THEN EXAMPLE 1
We run the program.
The dates are compared and If condition is fulfilled as true.
The Messagebox appears as expected.

EXAMPLE 2 OF IF THEN ELSE CONSTRUCT

Let us see some more examples

EXAMPLE 2

CREATE AN APPLICATION IN WHICH VBA TELLS YOU IF ITS WEEKEND OR NOT

CODE

‘GYANKOSH.NET Check if its weekend today or not
‘SIMPLE IF

Sub IfExample2()

    Dim we As String

    we = InputBox(“Enter the day”)   ‘INPUT FROM USER
    Dim weekend1 As String, weekend2 As String   ‘TWO STRINGS FOR WEEKEND

    weekend1 = “SATURDAY”                ‘WEEKEND DECLARATION
    weekend2 = “SUNDAY”

    If Ucase(we) = UCase(weekend1) Then         ‘CHECKING IF THE DAY IS WEEKEND
        MsgBox (“It is the Weekend! Enjoy”)

          ElseIf Ucase(we) = UCase(weekend2) Then
             MsgBox (“It is the Weekend! Enjoy”)

         Else
             MsgBox (” Weekend will come soon”)

    End If

End Sub

EXPLANATION

In this example, we take input from the user and compare it with the weekend days , one by one,

and return the result in a message box.

The comments are also given. Kindly go  through the code once and read the comments also.

We start with taking the input from the user, who gives us the Day Name.

After that we declare two more strings to keep the value of weekend days.i.e. saturday and sunday.

After this we start the IF STATEMENT.

The comparison is done between the input given by the user and the weekend days.

If the comparison is TRUE and values are same, it shows its a weekend else

it shows its not a weekend.(For any other day or input)

*You must be thinking about the UCASE  function. UCASE(STRING) capitalized all the words of a string. Its a style of comparison to make it foolproof. What if the user gave some input in small case or mixed case. For that we put this.

 

RUNNING THE CODE AND OUTPUT

RUNNING EXAMPLE 2 IN VBA
VBA -IF THEN EXAMPLE 2

The above picture shows the animation of running this program.

In this example we made the use of ELSEIF and ELSE too.

So we start with program.

An inputbox opens up and asks for the Day.

We enter the day and it is sent through the code and output appears.


OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: