PROGRAMMING WITH VBA - Quiz

1) What is the another name trigger for an action in VBA?

Methods Modules Events Macros

2) Which shortcut key allows debugger to run the current procedure and go line after line called the procedure in VBA?

Ctrl + Shift + F6 Ctrl + Shift + F7 Ctrl + Shift + F8 Ctrl + Shift + F9

3) While debugging code, which statement allows to go to the highlighted line?

Step into Step over Step out Show next

4) Which control is used to increase or decrease a value, such as a number time or date?

Scroll Bar Spin Button Combo Box Toggle Button

5) Which VBA function compares given strings and returns -1 if the first string is smaller than the second string, returns 0 if both are equal and 1 if the first string is greater than second string?

Strcmp Strcomp Compare Scmp