MicroStation VBA Verification Checklist (Steps that can help resolve most VBA: Crashes, Project Load, or Run issues)

1. Perform Microsoft Full Updates and Patching
   
   
   • Update Microsoft Windows (Version History) 
   • Update Microsoft Security and/or 3rd Party solutions
   • Update Microsoft Office Updates/Patching 
     
     NOTE: Verify (pendmoves) and Perform any Computer Reboots if prompted/required.
     
     
2. Start Software First Time and/or Install Software using "Run as Administrator"
   
   NOTE: This helps to ensure proper local admin rights/privileges and resources are allowed to finalize post install software needs (e.g. component registrations in registry, etc.) or software installer permission issues (network group policies constraints/conflicts) that can arise and do not provide sufficient user notification of an exact problem.  After First Start and/or Install as admin, in most cases Bentley software can then safely (unless noted otherwise in product documentation) be run in a Microsoft LUA (limited/restricted) user.
   
   
3. Verify the Microsoft VBA Project Compiles Cleanly
   
   
   • Verify the Imported - Project > References (No Missing / All Registered)
     
     • Open Microsoft VBA Editor. Highlight your Project. Select: Tools > References
     • Look for any References tagged with "MISSING". Remove Reference and update using Correct Path.
       
       
       
   • Verify all Project Files (Forms, Modules and Classes); first line of code should start with: 'Option Explicit
     
     
   • Verify the Project Compiles: Debug > Compile  (ProjectName)...
     
     
   • Lastly you may need to Unregister and/or Register controls. See: Microsoft Troubleshooting with Regsrv32
     
     
4. Reset MicroStation User Preferences and Temp Files
   1. See: How To Reset User Preferences and Delete MicroStation's Temporary Files
5. Troubleshoot Workspaces
6. Finding and Loading Apps and DLLs
   1. Search Paths
   2. Sharing VBA Projects on a Network (MS_VBA_OPEN_IN_MEMORY=[ ALL | READONLY ])
7. Debug your VBA Project
   1. Debugging MicroStation VBA
8. VBA Related Crashes/Exceptions
   
   1. Review and Verify steps listed in: MicroStation VBA crashes on startup after Microsoft Office Updates
   2. Remove all Application and ActiveX control object caches (*.box, *.exd)
      • Application Caches (*.box) files located: %APPDATA%\Microsoft\Forms
      • ActiveX Control Caches (*.exd) files located: %LOCALAPPDATA%\Temp\VBE
        
9. Microsoft 365/Office - VBA: Errors, Known Issues and FAQs
   • ERRORS
     1. VBA Class not Registered
   • KNOWN ISSUES
     • VBA Macros stopped working after Windows 11 Updates
       • Verify proper Microsoft Trust Center settings>Macro settings
       • Alternately, Repair an Office application
     • FAQ for VBA solutions affected by April 2020 Office security updates
       • How to Unblock VBA object Libraries
     • Word Office 365 cannot open VBA Password Protected Project
       • FIXED (Sept. 2022): Error "Invalid password" when opening a VBA project using the correct password
       • Mitigate VBA Projects having Passwords >7 characters
       • Alternately, How to revert to an earlier version of Office
   • FAQs
     • Microsoft 365, Office: 2021, 2019 and 2016 all have the same version 16.0
     • All installed products must be either the 32-bit version or the 64-bit version
     • Verify what Version and Edition of Microsoft 365/Office is installed
10. If Problems Persists
    
    1. Review MicroStation VBA Help Topics
       • "Changes for 64-bit Processes" (See also: Microsoft ActiveX Control Recommendations)
    2. Review MicroStation VBA Logging ("Run as Administrator")
       • Set MS_VBALOGGING=1 as an Operating System variable.
       • [Optionally] Set MS_VBA_LOG_PATH=%LOCALAPPDATA%\Bentley\Logs\MyVba.log; as an Operating System variable
       • Start MicroStation and reproduce the error
       • Locate and Review the log file generated: Default (C:\vba.log) or Optional Location.
    3. Review Microsoft Office VBA Permissions (When running MicroStation VBA code within Microsoft Office products)
    4. Troubleshoot File Sharing or Access Issues
       • Sharing VBA Projects on a Network
       • Microsoft Process Explorer (procexp)
       • Microsoft Handle
    5. Collect and Process Microsoft Data
       • Microsoft Process Monitor (procmon) and/or
       • Microsoft Full Memory Dump (primer)
    6. Perform a Clean Install.
       • Though an extreme measure and does not permit a "root cause" to be discovered using techniques above, sometimes a clean install is the most prompt way to bring a user back into production.  Doing so ensures a completely up-to-date and clean software environment from which the software is run in.  If time is of the essence this option may make the most sense.  However performing the steps above can often lead to identifying a root cause and permit software vendors to correct any quality issues or fixes required and help all users by producing documentation for how to quickly resolve the issue (if not under one specific vendor's control) for more users in the future.