Meta Thinking, Meta Working
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...
Distribute “Naver Korean Dictionary/English Dictionary Search Tool_v1.01_20220708” with one error corrected. The outline of Naver Korean and English dictionary search tools and how to use them are summarized in the article below. Overview of Naver Korean Dictionary/English Dictionary Search Tool Today (2022-07-08) the following comments were posted. https://prodtool.tistory.com/28#comment9159871 #ToDo: After reviewing whether to change the comment link, the following error message occurs. I checked with Fiddler...
The Naver Korean Dictionary/English Dictionary search tool operation method and source code are explained. This is a continuation of the previous article. Overview of the Naver Korean Dictionary/English Dictionary search tool processing result...
An overview of the Naver Korean Dictionary/English Dictionary search tool is explained. 1. Overview of Naver Korean Dictionary/English Dictionary Search Tool 1.1. Necessity Have you ever searched Naver Korean and English dictionaries and copied and pasted the search results manually into Excel? If you only have a few words (or terms) to search for, you can do it manually. But that...
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...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español