エクセルコンテンツ」カテゴリーアーカイブ

Introduction to Excel VBA

Excel VBA is a programming language used in the macro function that automates Excel operations.

VBA is short for “Microsoft Visual Basic Applications”

In this VBA introductory series As an introduction to macro VBA which is required in practice, we will explain VBA in general from basic to application.

Beginners and beginners should read from the beginning.
Even if there are parts that you don’t understand, it is also important to move forward.
Going forward, you may be able to understand what you couldn’t understand before.
By reviewing from time to time, you should be able to realize that your understanding has progressed.

For intermediate / advanced users, please refer to the required items from the table of contents.

Basics of VBA introduction

1.What is a macro? What is VBA?
2.First prepare to use Macro VBA
3.Macro recording
4.Where is the macro written (VBE startup)
5.VBE Set Options (Option Explicit)
6.Let’s write it anyway (Sub, End Sub)
7.To run a macro (F5)
8.What is putting a character in a cell (Range, Value)
9.How to specify cells in Range
10.Specification method other than Range (Cells, Rows, Columns)
11.How to use Range and Cells
12.Variables and data types (Dim)
13.Constants and type declaration characters (Const)
14.Character concatenation and continuation line
15.Four arithmetic operations and annotations (comments)
16.Iterative processing (For Next)
17.Iterative processing (Do Loop)
18.Get last row (End, Rows.Count)
19.General practice question 1

ExcelマクロVBAの速度対策

記述による処理速度の違い

速度比較決定版【Range,Cells,Do,For,For Each】

エクセルVBAのパフォーマンス・処理速度に関するレポート

マクロVBAの高速化・速度対策の具体的手順と検証

大量データで処理時間がかかる関数の対処方法(WorksheetFunction)

大量データにおける処理方法の速度王決定戦

遅い文字列結合を最速処理する方法について

 

Dir関数の制限についての解説

VBAでフォルダ・ファイルの存在確認や、
一覧取得において使われる関数ですが、
いくつかの使用上の注意点、制限事項があります。

・3桁拡張子の指定時の問題

・256バイトを超えるパス名が扱えない

・特殊なネットワークドライブでエラー

詳細解説はこちらです。