Excel VBA Cheat Sheet 2026

The 30 highest-yield Excel VBA facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. In VBA, which method adds a new worksheet to a workbook? → Worksheets.Add()
2. What does 'On Error Resume Next' do in VBA? → Allows execution to continue with the statement following the error
3. How do Excel VBA professionals evaluate research quality? → By assessing methodology, sample size, peer review status, and relevance to practice
4. Which error handling approach is most appropriate for production VBA code that needs to respond differently to multiple error types? → Use a GoTo handler with a Select Case block on Err.Number
5. How has digital technology transformed Excel VBA practice? → It has enhanced data collection, analysis, communication, and operational efficiency
6. What is the VBA constant for a newline character in a message box? → vbCrLf
7. Which of the following is the default data passing method in VBA? → ByRef
8. What does the Range.AutoFilter method do in VBA? → Applies or removes dropdown filter controls on a range
9. Which VBA debugging feature lets you monitor a specific variable or expression and optionally pause execution when its value changes? → Watch Expressions
10. What is the default lower bound for VBA arrays? → 0
11. Which keyword exits a Sub procedure immediately in VBA? → Exit Sub
12. What is the first step in risk assessment for Excel VBA professionals? → Identifying potential hazards and vulnerabilities in the specific context
13. Which of the following formulas will produce an integer between 1 and 10, inclusive, with a probability of 10% for each integer? → INT(10*RAND())+1
14. How should an Excel VBA professional respond to a compliance violation? → Report it promptly, investigate the root cause, and implement corrective actions
15. Which VBA data type stores True or False values? → Boolean
16. How does a Excel VBA professional communicate risks to stakeholders? → By presenting risks clearly with context, potential impacts, and recommended actions
17. Which tool is commonly used for root cause analysis in Excel VBA quality management? → Fishbone (Ishikawa) diagram to identify contributing factors systematically
18. What is the correct way to start a VBA subroutine? → Sub MySub()
19. What is the effect of using 'On Error GoTo 0' in a VBA procedure? → Disables any currently active error handler in the procedure
20. Which part of the VBA window corresponds to the code-writing area? → Module
21. Why is documentation important in Excel VBA risk management? → It creates an audit trail, supports decision-making, and demonstrates due diligence
22. How do you declare a dynamic array in VBA? → Dim arr() As Integer
23. Which keyword is used at the end of an error handler to return execution to the main code flow? → Resume
24. What role does peer review play in Excel VBA practice? → It provides quality assurance and professional development through collegial evaluation
25. Which VBA debugging action executes code one line at a time, including stepping into called procedures? → Step Into
26. What is the consequence of non-compliance for Excel VBA professionals? → Potential fines, license revocation, legal liability, and reputational damage
27. How should Excel VBA professionals prioritize identified risks? → Based on likelihood of occurrence combined with severity of potential impact
28. How do you find the last used row in column A using VBA? → Cells(Rows.Count, 1).End(xlUp).Row
29. What is the purpose of the On Error GoTo statement in VBA? → Redirects execution to an error-handling label when a runtime error occurs
30. What does 'Resume Next' do when placed inside a VBA error handler? → Continues execution with the statement after the one that caused the error