Grammer/Syntax

Question 0

What different types of values can the property of an object have?

Answer 0

Number: Range(“A4”).Value=4

Text: Range(“A4”).Value=”Rama”

Logical I.e., true or false: activecell.font.bold= True

Question 1

How do you access the property of an object that is contained within other objects?

Answer 1

activesheet.shapes(2).line.weight

Question 2

What is “method” in VBA?

Answer 2

It is a place holder for the action you want to perform on an object. For example, Range(“A4”).clearcontents

Question 3

The line continuation character in VBA is

Answer 3

Underscore preceded by a space.

Question 4

Code for row height

Answer 4

C.EntireRow.RowHeight

It’s not EntireRow.Height

Question 5

Can properties in turn be objects in VBA?

Answer 5

Let’s consider the Range object. You can change the appearance of the selected range of cells by setting the Font property. But the font can have a different name (Times New Roman, Arial,. ), different size (10, 12, 14,. ), and different style (bold, italic, underline,. ). These are font properties.

Question 6

3 types of clear methods are ______

Answer 6

Range.ClearContents
Range.ClearFormats
Range.Clear ( clears both formats and contents).

Question 7

How to save and close a workbook?

Answer 7

Workbooks(“book1.xlsm”).close SaveChanges:=True

Question 8

Where can we use the line continuation charecter?

Answer 8

You can use the line continuation character in your code before or after:
Operators, for example: &, +, Like, NOT, AND
A comma
A colon and an equals sign (:=)
An equals sign

Question 9

Where can we not use the line continuation charecter?

Answer 9

You cannot use the line continuation character between a colon and an equals sign