PROGRAMMING WITH VBA - Quiz

1) Which function returns the current system date and time in VBA?

Date() Day() Hour() Now()

2) Which function extracts the first 5 characters from a string in VBA?

Right(str,5) Left(str,5) Mid(str,5) Substr(str,5)

3) Which color of dot indicate the breakpoint in VBA?

Grey Yellow Maroon Red

4) Which shortcut key is used to set the properties of form while designing?

F4 Ctrl + F4 Alt + F4 Shift + F4

5) Which shortcut key is used to open code window in VBA?

F7 Alt + F7 Ctrl + F7 Shift + F7