VBA / Office

VBA / Office

Extracting IDs, Emails, and IPs from Logs Using Only Excel — Using REGEXEXTRACT / REGEXREPLACE

Using REGEXEXTRACT / REGEXREPLACE in Microsoft 365 Excel to extract IDs and IPs from log strings and easily mask email addresses.
2026.09.07
VBA / Office
VBA / Office

What Does VBA DoEvents Actually Do? — Understanding Why Screens Freeze and How Event Processing Works

This article delves into why VBA's DoEvents can restore Excel's responsiveness, exploring event processing, reentrancy, and the differences from asynchronous processing. It is designed to prevent treating DoEvents as a universal asynchronous solution.
2026.09.07
VBA / Office
VBA / Office

Safely Automating Other Applications with CreateObject in Office VBA

This article is a technical commentary and implementation example created using AI. The codes and procedures presented a...
2026.09.04
VBA / Office
VBA / Office

Checking the Excel VBA Object Model Hierarchy with a Small Macro

This article is a technical commentary and implementation example created using AI. The published code and procedures ar...
2026.09.03
VBA / Office
VBA / Office

Understanding the Excel VBA Range Object from the Ground Up

This article is a technical explanation and implementation example created using AI. Although the code and procedures pr...
2026.09.03
VBA / Office
VBA / Office

Creating Reusable Functions in Excel without VBA Using LAMBDA

This article is a technical explanation and implementation example created using AI. Although the code and procedures pr...
2026.08.31
VBA / Office