Meta Thinking, Meta Working
I have a new news related to VBA, so I write a brief article. From 2022-07-27, the execution of VBA macro files received from the Internet will be blocked. This is a security measure to prevent someone with malicious intent from distributing malicious code using macros. Only MS 365 Office apps running on Windows. Runs on Mac OS or installs...
Among the VBA coding patterns, look at the contents of Range Loop-Write. Summary Introducing coding patterns that improve performance when writing a lot of data in an Excel sheet using Variant Array. The article below has already covered how to improve performance when reading a lot of data from an Excel sheet. VBA coding patterns:...
Among the VBA coding patterns, look at the contents of Range Loop-Read. Summary Range Loop is a coding pattern often used when reading and processing data entered in an Excel sheet with VBA code. The basic pattern of reading sequentially from the start cell to the last cell, and reading at once without reading sequentially...
I'm uploading a separate table of contents for the entire Excel VBA lecture I've been writing. I put a link in the entire table of contents so that you can find this article as an index. Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) (prodskill.com) 1. Excel VBA Overview 1.1. VBA, Macro concept...
In this article, I look at examples of tools that I have developed and used with Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (9): Excel VBA How-To 5. Tools developed and used with Excel VBA 5.1. Naver Korean Dictionary, English Dictionary Search Tool This is an automated tool that searches Naver Korean and English dictionaries and imports the search results into Excel.
This article examines the Excel VBA How-To. Please refer to it when coding Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (8): Basic Excel VBA Language - Data type, Data structure 4. Excel VBA How-To 4.1. How to configure UI (User Interface) Receive input values from the user in Excel VBA or...
In this article, we look at the data type and the provided data structure among the basics of the Excel VBA language. This is a continuation of the previous article. Excel VBA Lecture (7): Basic Excel VBA Language - Syntax 3.3. Data types 3.3.1. Basic Data Types Data types supported by VB (or VBA) are summarized in the following table. Collection,...
This article looks at syntax among the basics of the Excel VBA language. This is a continuation of the previous article. Excel VBA Course (6): Excel VBA Language Basic-Variables 3.2. Language Syntax The VBA language syntax is the same as the Visual Basic syntax. You don't need to know all the syntax at first, just the syntax summarized here is sufficient. all...
In this article, we look at the contents of variables among the basics of the Excel VBA language. This is a continuation of the previous article. Excel VBA Lecture (5): Excel File Extension, VBE, Font Setting 3. Excel VBA Language Basics 3.1. Variables Examine variable declarations and binding methods. 3.1.1. Declare a variable with the following syntax...
This article examines the differences in Excel file extensions, VBE (Visual Basic Editor), and recommended font settings. This is a continuation of the previous article. Excel VBA Lecture (4): Handling Excel Object Model 2.6. Excel file extension Excel versions prior to 2007 had only one extension, '.xls'. Since Excel 2007 '.xlsx', 'xlsm', 'xlsb'...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español