Learn how to display a Save As dialog box using the VBA msoFileDialogSaveAs object. The VBA msoFileDialogSaveAs object has several properties and methods designed to help you interactively save your files.
Use VBA Workbook event handling to capture a variety of application-level events. The events captured in the VBA ThisWorkbook module can be used to trigger unique actions based on a user's interaction with Excel.
I used to be an average VBA programmer. When I pushed myself to improve, people noticed. Now, I want to share all the ways you can use VBA to work more efficiently and start building your own reputation as an office innovator.