Objects

Question 1

Name some objects in VBA

Answer 1

Application, Workbooks, Workbook, Sheets, Worksheets, Worksheet, Range, Shapes, Shape, Declaring and Assigning an Object Variable

Question 2

Difference between using Range or Cell function

Answer 2

Range takes cell address and can reference multiple cells.
Cell takes both row and column reference and returns only one cell.

Question 3

What is looping?

Answer 3

Loops allow you to go through a set of objects/values and analyze it one by one. Specific tasks can also be performed for each loop.

Question 4

What are the different kinds of loops?

Answer 4

1. For Next Loop
2. Do While Loop
3. Do Until Loop
4. For Each Loop

Question 5

What does the For Next Loop do?

Answer 5

You specify how many time you want the loop to run and what you want the code to do.

Question 6

What does the Do While Loop do?

Answer 6

This checks for a condition and run the loop while that condition is met (or is TRUE).

Question 7

What does the Do Until Loop do?

Answer 7

Do Until loops until the specified condition is met. Compared to Do While Loop, which loops until the given condition is met.

Question 8

What does the For Each Loop do?

Answer 8

This loops through a set of collections.