VBA & macros
Automate repeat work with macros and VBA code.
- Excel Protect VBA Code: Lock Your MacrosYes, you can protect VBA code in Excel by locking the VBA project with a password, which prevents others from viewing or…
- Excel and Access VBA: What It Is and How to Use ItExcel and Access VBA (Visual Basic for Applications) is a programming language built into Microsoft Office that lets you automate repetitive tasks,…
- VBA Script to Send Email From Excel With OutlookTo send an email from Excel on Windows, use a VBA macro to create an Outlook message, fill in its recipient, subject,…
- VBA Excel Get Range Address: Examples and Common UsesIn Excel VBA, get a range’s address with its Address property: for example, Range("B2:D5").Address returns $B$2:$D$5 by default. Set the property’s optional…
- VBA Excel Dictionary Example: Code and SetupA VBA Dictionary stores values under unique keys, making it useful for fast lookups and totals by name or code. In Excel…
- Tiny Excel Macro: How to Record Small Repetitive Tasks in ExcelTo record a tiny task in Excel for Microsoft 365 on Windows, open the Developer tab, choose Record Macro, perform the repeatable…
- SteelSeries Macro Editor: Create and Assign MacrosTo use the SteelSeries Macro Editor, open SteelSeries GG, select a compatible device in Engine, choose a key or button, assign a…
- MS Access Split String: VBA Syntax and ExamplesYes. In Microsoft Access, VBA’s Split function breaks a string into a zero-based array of pieces using a delimiter such as a…
- Macro Tiny Task Tracker: Build a Simple Excel ToolIf by “macro tiny task tracker” you mean a compact task list in Excel that uses a macro to add tasks, yes:…
- Controller Macro Setup: Step-by-Step Guide for GamingTo set up a macro on a controller, connect a model that supports button sequences, open its official configuration software, create and…
- How to Set a Macro in ExcelIn Excel for Microsoft 365 on Windows, set a macro by opening a workbook, choosing Developer > Record Macro, performing the actions…
- How to Activate a SteelSeries MacroTo activate a SteelSeries macro, open SteelSeries GG, select your supported device under Engine, assign a saved macro to a key or…
- How to Set Up a Macro on a SteelSeries Mouse with GGTo put a macro on a SteelSeries mouse, install SteelSeries GG, open Engine, select your mouse, assign a button to a macro,…
- Excel Macro Tiny Task Manager: Build a Simple ListIf you mean a tiny task manager built with an Excel macro, yes: a short VBA macro can create a basic task…
- SteelSeries Macro Setup: Record and Assign KeysTo set up a SteelSeries macro, open SteelSeries GG, select your device in Engine, choose the button or key to customize, and…
- VBA For Each Split: Loop Through Text PartsTo loop through text separated by a delimiter in VBA, use For Each with the array returned by Split, and declare the…
- TinyTask Macro: How to Record, Save, and Run TasksTo set up a TinyTask macro on Windows, open TinyTask, click Record, carry out the actions you want automated, then stop the…
- Split String in VBA: Syntax and Practical ExamplesUse VBA’s built-in Split function to divide a string into a zero-based array: parts = Split(text, delimiter). For example, Split("red,green,blue", ",") returns…
- Best Revolution Macro Settings for RuneScape 3 CombatFor most RuneScape 3 players, the best Revolution setup is a hybrid: let Revolution activate a well-ordered set of basic abilities, but…
- TinyTask Macro: Is It Free and How Does It Work?Yes. TinyTask is a free, lightweight Windows utility that records mouse and keyboard actions and plays them back as a macro. It…
- VBA Function Return String: Syntax and ExamplesYes. A VBA function returns a string when its declaration ends in As String; inside the function, assign the value to the…
- Best Excel Macro Settings for Every Use CaseFor most people using Excel for Microsoft 365 on Windows, the best choice is Disable VBA macros with notification. It keeps macros…
- MS Access VBA Enum: Syntax, Examples, and Best PracticesAn Enum in Microsoft Access VBA is a named set of numeric constants. Declare it at the top of a standard module,…
- SteelSeries GG Macro Editor: Setup, Uses and FixesThe SteelSeries GG Macro Editor is a tool within SteelSeries GG’s Engine section for creating input sequences and assigning them to supported…
- SteelSeries Rival 3 Macro: Setup and LimitsYes. The SteelSeries Rival 3 can use macros through SteelSeries GG’s Engine controls: select the mouse, assign a macro to a programmable…
- VBA Quotes in Strings: How to Include Double QuotesTo put a double quote inside a VBA string, double it: write "" inside the surrounding string literal. For example, "She said…
- SteelSeries Macros: How to Create and Assign OneTo get a macro on a SteelSeries device, open SteelSeries GG, choose your device in Engine, create or record a macro in…
- String in VBA: Meaning, Types, and Practical ExamplesIn VBA, String is the data type used to store text, such as names, messages, codes, and text read from cells. Declare…
- VBA Enum For Each: How to Loop Through ValuesYou cannot use For Each directly on a VBA Enum: an enum defines named numeric constants, not a collection of items. To…
- How to Turn Off a TinyTask Macro and Stop PlaybackTo stop a TinyTask macro that is playing, press TinyTask’s Play/stop hotkey—Ctrl+Shift+Alt+P by default—or click the Play button. If the macro is…