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.
We just added a 6th cheat sheet to our training bundle. With our new guide on VBA UserForms, our bundle now has over 200 tips like how to automate data extraction from text files, how to remove duplicates from an array, and how to dynamically populate a listbox.
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.