Category: Excel & VBA

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