|

Basic VBA Intro

ByPeter J Pendleton

[fusion_builder_container background_color=”#fed03d” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_aspect_ratio=”16:9″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_style=”solid” padding_top=”50″ padding_bottom=”50″ hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” admin_label=”Container”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=”” min_height=””][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]

Basic VBA Interview Questions and Answers

Here are the most commonly asked Basic VBA Questions and Answers covered from Basics of VBA Programming.

  1. What is VBA?
    1. VBA stands for Visual Basic for Applications.
    2. VBA is Programming language available in MS Office Tools.
  2. What are Data-types?
    Data types helps to declare Variables with specific data, this helps to VBA to know the type of the data and assign the memory based on the DataType of the Variable.
  3. Name some data types?
    Boolean
    Byte
    Currency
    Date
    Double
    Integer
    Long
    LongLong
    LongPtr
    Object
    Single
    String
    Variant
  4. What is Variant Data Type and Explain it?
    Variant data type is default data type and it can hold any type of data. This will allocate maximum memory to hold the Varian Type. We use Variant data-type when we dot know the type of the data or to accept the multiple data types in a single variable.
  5. What are Scope of Variables?
    We can define variable in different levels:
    Local Level: Variables which are defined with DIM statement in a procedure or functions
    Module Level: Which are defined with DIM statement on top of a module, can be accessed in entire module
    Global Level: Which are defined Public statement at top of any module, can be accessed in entire project.

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” background_position=”left top” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” border_size=”0px” border_style=”solid” padding_top=”3%” padding_bottom=”2%”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ spacing=”yes” center_content=”no” hover_type=”none” link=”” min_height=”” hide_on_mobile=”no” class=”” id=”” background_color=”” background_image=”” background_position=”left top” undefined=”” background_repeat=”no-repeat” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding_top=”0px” padding_right=”15%” padding_bottom=”0px” padding_left=”15%” margin_top=”50px” margin_bottom=”25px” animation_type=”” animation_direction=”left” animation_speed=”0.1″ animation_offset=”” last=”no”][fusion_blog layout=”large” blog_grid_columns=”2″ blog_grid_column_spacing=”40″ orderby=”date” order=”DESC” thumbnail=”yes” title=”yes” title_link=”yes” excerpt=”yes” excerpt_length=”40″ strip_html=”yes” meta_all=”yes” meta_author=”yes” meta_categories=”yes” meta_comments=”no” meta_date=”no” meta_link=”yes” meta_tags=”no” scrolling=”pagination” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” /][fusion_accordion type=”toggles” boxed_mode=”” border_size=”1″ border_color=”” background_color=”” hover_color=”” divider_line=”” title_font_size=”” icon_size=”” icon_color=”” icon_boxed_mode=”” icon_box_color=”” icon_alignment=”” toggle_hover_accent_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””][fusion_toggle title=”What is VBA?” open=”no”]

  • VBA stands for Visual Basic for Applications.
  • VBA is Programming language available in MS Office Tools.

[/fusion_toggle][fusion_toggle title=”What are Data-types?” open=”no”]

Data types helps to declare Variables with specific data, this helps to VBA to know the type of the data and assign the memory based on the DataType of the Variable

[/fusion_toggle][fusion_toggle title=”What are data types?” open=”no”]

  1. Boolean
  2. Byte
  3. Currency
  4. Date
  5. Double
  6. Integer
  7. Long
  8. LongLong
  9. LongPtr
  10. Object
  11. Single
  12. String
  13. Variant

[/fusion_toggle][fusion_toggle title=”What is Variant Data Type and Explain it?” open=”no”]

Variant data type is default data type and it can hold any type of data. This will allocate maximum memory to hold the Varian Type. We use Variant data-type when we dot know the type of the data or to accept the multiple data types in a single variable.

[/fusion_toggle][fusion_toggle title=”What are Scope of Variables?” open=”no”]

Variables are defined in different levels:
  • Local Level: Variables which are defined with DIM statement in a procedure or functions
  • Module Level: Which are defined with DIM statement on top of a module, can be accessed in entire module
  • Global Level: Which are defined Public statement at top of any module, can be accessed in entire project.

[/fusion_toggle][fusion_toggle title=”What are Arrays?” open=”no”]

Arrays are type of variables allows to store multiple data values in one variable. It can contain multiple Dimensions like 2-dimensions, 3-dimensions,etc.

[/fusion_toggle][fusion_toggle title=”How to increase the Size of the Array?” open=”no”]

 We can redefine the size of the array using REDIM statement. We use PARSE statement will to keep the previously stored data in the data.

[/fusion_toggle][fusion_toggle title=”Your Content Goes Here” open=”no”]Your Content Goes Here[/fusion_toggle][fusion_toggle title=”Your Content Goes Here” open=”no”]Your Content Goes Here[/fusion_toggle][/fusion_accordion][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]