VBA Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 22% • Most missed: “Which of the following would you begin a comment line with?”
VBA Fundamentals Test
Time left 00:00
25 Questions

1. Month(#12/25/02#) will output?
2. Output of below code: Dim a As Integer Dim b As Integer a = 1000 b = 33 MsgBox a * b
3. Which Will Not display VBA code?
4. What reference will you add to add active x objects - i.e. buttons - at runtime?
5. When integrating Excel - which VBA code will allow you transfer data from recordset??xRec??in Access directly onto a spreadsheet (xlws) in Excel.
6. When stepping through code as a way to see how the values in variables change - use the:
7. How do you figure out the number of items in a collection?
8. What is the difference between these commands CreateObject('Word.Application') GetObject( - 'Word.Application')
9. What does a VBA macro consist of?
10. A VBA unit is called a _____.
11. Combine into one line: If x > 5 Then y = x - 5 End If
12. Which of the following functions do not perform a calculation
13. Which of the following would you begin a comment line with?
14. Choose the VBA code that will allow you to check to see if the form MainMenufrm is loaded.
15. Is it possible to expand storage space for dynamic Array variables with two or more dimensions - keeping the existing data?
16. 'Do While x < 5' is equivalent to:
17. Choose the VBA code used to close database and the Microsoft Access instance.
18. Which worksheet event can be used to run a procedure upon deleting the contents of a cell?
19. Is it possible to create an array with the lowerbound being two?
20. What does VBA mean?
21. Which statement will assign a random integer from 1 to 5 to the variable x?
22. Choose the VBA code to execute a Word MailMerge in Access
23. Under which menu option in the VBA IDE can you password protect a VBA project?
24. To save a VBA project with an Excel workbook - the workbook must be saved as what type of file?
25. Which of the following snippets of VBA code is not a loop?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Visual Basic Visual Basic Fundamentals Test Programming in Visual Basic Practice Test: Working With Database Visual Basic 6 Fundamentals Test Visual Basic for Applications (VBA) Quiz VB.NET Fundamentals Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.