VBA Interview Questions - Part 1 - Basic questions

-

Hello Readers,

Welcome to Coding by Learning !!! 😀 

1. What is VBA?

VBA stands for Visual basic for application.

2. Who developed VBA?

 VBA is created my Microsoft developers team. 

3. Where developer can write VBA code?

All office based application has in-built with VBA editor. Developer needs to write their code in the editor.

How to access VBA code editor/IDE

Way1

We can access it using keyboard short cut Alt+F11.

Way2

Navigate File -> Options -> Customize Ribbon -> click on the check box next “Developer” under Main tabs - > Ok



Go to Developer Menu and click on Visual Basic



4. What is basic object model of excel application?

Application -> Workbook -> Worksheet -> Range/Charts

5. What is option explicit?

Option explicit making declaration of variables mandatory. For more details refer my blog link : Option Explicit


Happy learning & Happy coding!!!

Comment and share this post to your friends and colleagues 😀

Comments

  1. Lakshman31 May 2022 at 03:16

    Very nice explanation....😀

    ReplyDelete
  2. Ram31 May 2022 at 22:53

    Thanks for the support :)

    ReplyDelete
  3. Priya5 June 2022 at 01:14

    Great! It is a good move to teach us in interview point of view. We have to face such questions first before entering into practical rounds.

    ReplyDelete
    Replies
    1. Ram5 June 2022 at 20:06

      Thanks for the support, we will try to post more blogs in this regard :)

      Delete

Post a Comment

Popular posts from this blog

VBA Interview Questions - Part 2 - Variables and Data types

-
Hello Readers, Welcome to Coding by Learning !!! 😀  6. What is data type? As name says it defines type of data the value holds that can be stored in to variable 7. What are different data types available in VBA? VBA has multiple data types in order to handle data for the programming. Some of the major data types which often be used are: integer, single, long, double, range, date, variant, object 8. What is Variant data type? Variant is the special data type which can accept any type of data. Variable which is declared as variant will get data type based on the value it is assigned 9. How to declare a variable in VBA? Using Dim keyword variable will be declared in VBA.  Syntax is :   Dim VariableName As Datatype 10. Is it possible to declare a variable without data type in VBA? If yes, What data type it holds? It is possible. If developer declares a variable without mentioned any data type then it will be considered as variant data type.  Happy learning & ...
Read more

VBA Interview questions - screen updating

-
Image
Hello Readers, Welcome to Coding by Learning !!! 😀  Take this scenario. There is an automation requirement where there is a master data file. User manually copy paste some range/cell to master file. Lets consider user needs to copy from 20 files to master file. Developer  automated this manual entry/copy paste activity using VBA code. But after the deployment user feels while running the code, it keeps changing the input file, copying  required data, going to master file, pasting data to master file, going to input file, copying required data, pasting data to master file and the activity continues until loop runs. As a user system looks like flipping pages of book which does not look good. Basically users wants to see only output after running automation. System screen should stay in the VBA macro file until getting output. How you make the code user convenience. Here VBA concept screen updating comes into picture . It is question might be asked in almost all the VBA int...
Read more

VBA Interview questions - Part 3 - Array concept

-
Image
Hello Readers, Welcome to Coding by Learning !!! 😀  Lets see interview questions on VBA array concepts. 1. What is array? Array is a group of elements of similar data types 2. How to declare a array variable? Syntax : Dim arrayVariableName(size) As Datatype Ex : Dim fruits(5) As String 3. What is ReDim keyword in VBA? Using ReDim keyword developer can redefine the size of an array 4. How to use ReDim in VBA? Syntax : ReDim arrayVariableName(size) As Datatype   Ex : ReDim fruits(10) As String 5. I have already stored some elements in the array, what will happen if I redefine the size? When you redefine the size of an array without preserve keyword, then already stored elements will be erased from the array 6. What is preserve keyword in VBA? Preserve keyword in VBA helps to retain already stored elements in the array even though it is redefined. Example :  ReDim Preserve fruits(10) As String 7. What is option base in VBA? Option base is related with array concepts....
Read more