Posts Tagged ‘sales’

The Class and Property Builders make it easier to create and use properties in classes in VBA. Class Builder The Class Builder creates a Class Module with specified properties. To use the Class Builder you only need to enter two things: Clicking the “Create” button adds the class: Property Builder The property builder will add…

The Procedure Builder (ALT + P) quickly generates a procedure with specific settings (ScreenUpdating, etc.). You can save your default procedure settings to save time when writing new procedures. Output: Use Cases Save Settings as Default To save your current settings as default (for easy access in the future), click the bottom in the bottom-right…

The Array Builder is found within the Array menu in the VBA Editor: Use the Array Builder to create Arrays, Dictionaries, and Collections and manipulate them. VBA: Intro to Arrays, Dictionaries, and Collections Arrays, dictionaries, and collections are used to store information. Dictionaries and collections are like lists of data that can have a key.…

The SelectBox Builder is found within the UI menu in the VBA Editor: and in the Excel Ribbon: SelectBox User Interface A SelectBox is an User Interface that prompts the user of your spreadsheet to select one or more items from a list, triggering automation based on the user’s selection(s). Use Cases: SelectBox Macros allow…

The Message Box Builder generates code for Message Boxes and Input Boxes. It can be found in the UI menu of the VBA Editor: And in the Excel Ribbon: Message Box Message Boxes are used to prompt users. The default MessageBox (vbOKOnly), communicates information and simply asks the user to click ‘ok’. Other MessageBox types require users to…

With AutoMacro, you can easily create your own code library inside the VBA Editor. To add a new folder, click the Add Folder button: Or, use the “Edit” Menu to create your folder structure (see below for more information). Add Code to Library To add code to the library: Save Code from AI Code Generator…

File Dialog Box Builder The FileDialogBox Builder creates a Dialog Box that users can use to Open File(s), Save File As, Select File(s), or Select Folder(s). You can easily specify the default folder path, file types, and more. Before we demonstrate how to use the tool, review these two examples: Save As Creates a button…

Copy Paste Builder The Copy Paste Builder automates the process of copying and pasting ranges of cells. It’s found here in the VBA Editor: Or here in the Excel Ribbon: Use Cases How to Use the Copy Paste Builder To use the Copy Paste Builder, simply enter the copy range and the paste range: Then…

With AutoMacro, you choose how to deploy your automations (Macros) with the Insert Macro menu. The menu will appear after you’ve selected a Macro to create. At the top of the Menu you’ll see a description of the Macro along with the Edit Macro button: By clicking “Edit Macro”, you can edit the Macro before…

Tools Toolbar Most of AutoMacro’s tools can be accessed via the Tools Toolbar inside the VBA Editor: Some can also be accessed via the right-click menu: AI With an active subscription, you can access AutoMacro’s AI features: The AI tools include: Learn More about the AI features. Code Explorer AutoMacro’s Code Explorer improves upon the…