VBA– tag –
-
[Excel VBA] How to Change Scatter Plot Line Thickness Based on Cell Value
Background When visualizing data using multiple scatter plots in Excel, manually adjusting the line thickness for each chart individually can be tedious. It is often desirable to change the line thickness dynamically. This article introd... -
[VBA] How to Automatically Close a UserForm After Execution | Using Unload Me
Background When creating tools using UserForms in Excel, I was bothered by the fact that the form remained on the screen even after the program was executed. It looked cluttered, and I wanted to close the form to clearly indicate that th... -
[VBA] How to Delete Rows with Past Dates in Word Tables | Automatically Clean Up Expired Rows
When managing schedules or logs in Word tables, you often need to delete rows containing dates that have already passed. This article introduces a VBA code snippet that automatically deletes rows with dates earlier than "today." Goal Tar... -
[VBA Beginner] How to Automate the “Fill Handle” (AutoFill) in Excel
Environment Edition: Windows 10 Pro Version: 20H2 Background In Excel, you often drag the small square (Fill Handle) at the bottom right of a cell to copy formulas or values continuously. I wanted to automate this operation using VBA. In... -
[VBA] How to Automatically Highlight the Selected Row | Improving Visibility in Excel
Background When working in Excel, you might lose track of which row you were looking at because there are too many columns. This is common with horizontal scrolling or long tables where it is easy to lose sight of the row containing the ... -
[VBA Beginner] How to Check if a Cell is Blank | Implementing Input Checks with If Statements
When using Excel VBA, you may encounter situations like: "It will be a problem if the macro runs while a cell is blank..." "This is a mandatory field, but it hasn't been filled in..." This article introduces how to use VBA to determine i... -
[VBA x Outlook] How to Automatically Send Application Forms via Email | Attach and Send Excel Files Instantly
Background I used to manually attach Excel application forms to Outlook emails every time I created one. Since the recipient and the body of the email were almost always the same, I thought, "Can I automate this with VBA?" and decided to... -
[VBA] How to Input Text into Specified Cells in Word Tables | Basic Syntax for Coordinate Control
Background In Excel, you can easily specify cells using addresses like "A1" or "F6," but Word does not have this kind of cell notation. I investigated how to input text at a specific coordinate position in a Word table. As a result, I fo... -
[VBA] How to Automatically Paste Excel Charts into PowerPoint
Copying and pasting charts created in Excel into PowerPoint slides manually can be a hassle. In this article, I will share the code and steps to automate pasting graphs from Excel to PowerPoint using VBA. Objectives Paste an existing cha... -
[Excel VBA] How to Automatically Move the Cursor Right After Input
Background Normally, when you enter a value in an Excel cell and press the Enter key, the cursor moves down (vertically). However, when entering data sequentially by row (e.g., filling out a record), it is often more efficient for the cu... -
[VBA] Macro to Close Bento Orders in Excel | Auto-Lock by Date
Background In an Excel file used to manage bento (lunch) orders, there was a specific need: "Prevent inputs in the next day's order column after a certain time." Previously, this was done by manually locking the cells. To automate this, ... -
[Excel VBA] Change Cell Color to Yellow with “F9” and Red with “F10”
Background Previously, I created a tool where "pressing the F9 key runs code within a specific cell range." This time, I tried to expand functionality to support both the F9 and F10 keys. Specifications Target Range: Cells S1:S3. F9 Key:... -
[Excel VBA] How to Automatically Record Save History | Log Who Saved When
When sharing Excel files, issues often arise where it is unclear "who saved the file and when" or "who is responsible for an entry error." To prevent such troubles, it is recommended to implement a system that automatically records the s... -
[VBA] How to Centralize Common Logic for Multiple Sheets in ThisWorkbook | Avoid Writing Code for Each Sheet
Background While creating VBA programs in Excel, I often found it inconvenient to write the same code repeatedly for multiple sheets. Duplicate code leads to poor maintainability. Every time specifications change, code in all sheets must... -
[Excel VBA] How to Automatically Move to Cell A1 When Opening a File (Using ThisWorkbook)
Introduction "When you show an Excel file to someone, always make sure it opens at cell A1." Have you ever been given this rule by a supervisor? It is a common courtesy in business to ensure files look neat immediately upon opening. Howe... -
[PowerPoint] How to Execute Macros from the Ribbon Using Custom UI Editor
Background When creating tools with PowerPoint VBA, placing buttons directly on slides can look unpolished. Adding a custom tab to the Ribbon (header area) provides a seamless, application-like experience. This article summarizes how to ... -
[VBA] How to Randomly Select a Cell and Input a Value
Background While developing a tool in VBA, I encountered a situation where I needed to "randomly select one cell from a list and input a value into it." I realized this could be applied to creating seating charts or random assignment tas... -
[Word VBA] How to Automatically Insert Today’s Date on the Second Line | Right-Aligned “Update Date”
When creating documents in Word, do you ever find it tedious to manually type the date, such as "Update Date," every time? In this article, I will introduce a method using Word VBA to automatically insert today's date in the format "Upda... -
[Excel VBA] How to Create a Dashboard That Displays Graphs on Button Click
When summarizing information visually in Excel, it is very convenient to have a "dashboard where charts appear when a button is pressed." In this article, I will introduce a method using VBA to copy charts from another sheet and display ... -
[Excel VBA] Macro to Automatically Print a Specific Sheet (Printing Sheet1)
Background I often encounter situations where I need to print specific Excel files regularly. Thinking, "It would be convenient to print with a single click without opening the print settings every time," I wrote a VBA macro to automatic... -
[Excel VBA] How to Prevent Actions When a Cell Value Exceeds a Limit
Overview I am using Excel VBA to manage inventory. We had a rule: "Report if the total weight goes over 30g." However, this rule was often ignored, causing problems. So, I decided to enforce it with a system: "If the total is over 30g, d... -
[Excel VBA] How to Delete All Charts on a Specific Sheet (Using ChartObjects)
Background When creating multiple charts on an Excel sheet, you may encounter situations where you want to delete them all at once. In my case, I had a sheet serving as a "Dashboard" with many charts placed on it. Since deleting every ch... -
[VBA] How to Split Strings by Colon to Extract Specific Data (Reading Dates from CSV)
Background When processing external CSV files, you often need to extract only a specific part of a text string contained in a cell. For example, if cell A1 of a CSV file contains the string "Date:20240831", you might want to retrieve onl... -
[PowerPoint VBA] How to Open an Excel File Selection Dialog from a UserForm
Background When building tools in PowerPoint VBA, there is often a need to "open a dialog to select an Excel file using a UserForm." Instead of asking users to type a file path manually, allowing them to select it via a file dialog is mo... -
[VBA] How to Jump to a Specific Cell by Pressing “F9” Within a Specific Range
Background A colleague asked me for a specific feature: "When the cursor is between cells F9 and F16, I want the cursor to jump to J7 when I press a specific key." I implemented this using VBA. In this example, I used the F9 key as the t... -
[Excel VBA] Tired of Enabling Macros Every Time? How to Auto-Enable Them Safely
Background Every time I open a macro-enabled Excel file (.xlsm), a message bar appears asking, "Enable Content?" If you use macros daily, clicking this button every single time can become annoying. I decided to summarize how to set macro... -
[VBA] How to Turn Off Option Buttons by Default in a UserForm
Introduction In this post, I will share how to set Option Buttons (also known as Radio Buttons) on a UserForm to be unselected (OFF) by default. Environment: OS: Windows 10 Pro Version: 20H2 Background I placed two option buttons, "Yes" ... -
[VBA] How to Get a Value from a Word Table and Search for It in Excel using InStr
Background Unlike Excel, Word does not have the concept of cell addresses like "A1" or "F6". Therefore, I investigated how to extract data from a specific position in a Word table and search for that data within an Excel file. I achieved... -
[Word × VBA] Macros Can Be Used in Word Too! A Detailed Guide on Recording and Running Macros
Introduction It is a common misconception that VBA (Macros) is exclusive to Excel. In reality, Microsoft Word also features a "Developer" tab and supports VBA functionality. By utilizing Word VBA, you can automate repetitive tasks and st... -
[PowerPoint VBA] How to Display a Message Box Listing Shape Names and Types
Background I am currently working with PowerPoint VBA. I wanted to create a feature that "displays a message box listing the name and type of every shape on a slide." Here is the solution I implemented. The Code Below is the VBA code. Th...
