VBA Training

VBA enables non-programmers to record, create, and edit macros that can automate tasks in Office application.

• True

• False

What is the shortcut key to open Visual Basic Editor?

• ALT+CTRL+F11

• SHIFT+F11

• ALT+F11

• CTRL+F11

A VBA (a)   is used to store any VBA code that you have written in the VBE (Visual Basic Editor)

There's a feature in excel VBA to password protect the VBA Codes.

• True

• False

A Sub procedure can take arguments, such as:

• Constants

• Variables

• Expressions

• All of the above.

Following are the actions we can do in Excel VBA except:

• Respond to chats in MS teams through excel VBA.

• Automate copy paste of data from different workbooks.

• Automate pdf printing of invoices.

• Shutdown PC through excel VBA.

It is possible to automate e-mail sending through excel VBA.

• True

• False

Formula (a)   allows you set or retrieve formula for a cell, using relative row and column.

Which is not type of VBA Module?

• Standard modules

• Special Module

• Object Modules

• Class Modules

You can NOT rename modules.

• True

• False