Tagged: Excel VBA

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

This is the first article of the main part of the previous Excel VBA lecture preview. Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) 1. Excel VBA Overview A function written in VBA language similar to VB is called Macro. 1.1. VBA, Macro concept VBA (Visual Basic for Application) is a development language (and...

I am planning to organize the Excel VBA PPT materials that I presented to company employees a few years ago and post them on my blog. It may be a little difficult for those who have no coding experience in programming languages, but I will try to explain it as simply as possible. 😅 If you use Excel VBA well, your work productivity will increase and the quality of your output will increase....