Vba Notebook

vba microsoft doc

Logging

• install framework

Common function

• InStr：指定另一個字串內某個字串的第一個出現位置
• split
• replace

data structure

• ArrayList
  • https://excelmacromastery.com/vba-arraylist/
  • https://www.automateexcel.com/vba/arraylist/
• Dictionary
• Dictionary-for each
• Array
• Array-for each

How to Select a Range/Cell using

• How to Select a Range/Cell using VBA in Excel
• How to Select a Range of Cells on the Active Worksheet
• Can a VBA function in Excel return a range?

VBA overloading

• Function Overloading

conversion

• 類型轉換函數

special case

• How To Use VBA Code To Copy Text To The Clipboard
• regular expression
• regular expression 101
• VBA Copy to Clipboard
• paste clipboard to outlook with vba
• Add a Hyperlink with VBA
• VBA Regex
• VBA Send Emails from Excel through Outlook

tip

• 物件assign must using keyword Set

vba tutorial

• Excel VBA 的眉眉角角
• automat excel
• Excel Regex Tutorial

python

• setting task schedule

---

reference

• Logging for VBA - official site