Posts Tagged ‘sales’

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. For example, you create a list of all items a store sells and…

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 end-user of your spreadsheet to perform certain automations. SelectBox Builder – How to SelectBoxes are not included…

The Message Box Builder generates code for Message Boxes and Input Boxes. It can be found in the UI menu: 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 make a choice (Exs. OK / Cancel, Retry /…

With AutoMacro, you can easily create your own code library. 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 You can also add…

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. 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 you can choose between several options. Copy or Cut Click to learn more…

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: 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: Click Learn More to learn more about these features. Code Explorer AutoMacro’s Code Explorer improves upon the VBA…

UserForms are customizable forms that can be used to convey or receive information to/from a user. The UserForm builder makes it much easier to create well-designed UserForms. As you create your UserForm, you can see a preview of the form to the right of the UserForm Builder: The OK and Cancel buttons are automatically added…

Working with text is an important part of working with VBA. You need to be able to communicate information to users, whether it be a simple message box, UserForm, or text in Excel. The String Builder converts your written text into a usable string of text. It interprets line-breaks, special characters (quotations), and makes use…