Category: Excel VBA Courses

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'...

In this article, we will look at how to handle the Excel Object Model. 2.4. Understanding the Excel Object Model with Simple Code 2.4.1. Basic Object Access Let's look at the most basic code that accesses files, sheets, ranges, and cells. For reference, the global object Application can be omitted when accessing the object. 1 below...

2.3. Excel Object Model Excel VBA is a programming language that handles Excel. More precisely, it is a language that handles Excel's Object Model. You need to know how Excel is structured to be able to handle it well. If you understand just one picture below, the most important and frequently used in Excel Object Model...

2. Excel VBA Basics 2.1. Basic Environment Settings To use VBA-related functions, first set the Developer tab to be visible on the Excel ribbon menu. Depending on the Excel version, the displayed screen is slightly different, but the method is almost the same. Run Excel and proceed with the following steps to set it up. File > Options >...