I. Excel

① Excel document structure

② Insert ComboBox reference to list use name alias

③ Form Controls

④ ActiveX Controls

⑤ Delete Shapes (Form Controls / ActiveX Controls / Picture)

⑥ Reference

- https://vbabeginner.net/

- https://www.automateexcel.com/vba-code-examples/

- https://www.excel-easy.com/vba.html

II.VBA

①　Application_produce

　・Disable dialog alerts when close, save, ... workbook

    ・InputTextBox

② Data_type

    ・Basic data type: int, long, double, string, boolean, object

    ・Enum

    ・User define struct: type

    ・Array

    ・Dictionary

③ Debug_print

    ・How to use Debug.Print

④ Decisions

    ・If else

    ・Select case

⑤ Environ_produce

   ・Get value of environment variable 

⑥ File_folder

   ・Get link folder

   ・Check folder / file exists

   ・Scan files in folder

⑦ File_folder_dialog

   ・Select file dialog

   ・Save file dialog

   ・Select folder dialog

⑧ File_ReadWrite

   ・Read file

   ・Write file

⑨ Goto_label

   ・Goto

   ・Label

⑩ Loop_process

   ・For / For Each

   ・While

   ・Do While, Do Until

  ・Exit Do, Exit For

⑪ Sub_function

   ・Sub and Function

   ・Input parameter with ByVal and ByRef

⑫ With_produce

   ・Using With tag for workbook, worksheet, ....

⑬ Workbook_produce

   ・Structure of excel document: Workbook, Worksheet, Cell/Range

   ・Add new / open / save workbook

   ・Active, list all workbook

   ・ThisWorkbook / ActiveWorkbook

⑭ Worksheet_produce

   ・Select / copy / list all worksheet 

   ・ActiveSheet

⑮ Worksheet_Cell_Range

   ・Select Rows / Columns

   ・Cells / Range

   ・Determine last row / column ussing Cell(i,j).End 

   ・Find text

   ・Change Columns address by number ⇔ text

⑯ WScript_shell

   ・Run shell command and get return code

   ・Run shell command and get output string

 ※Command run in background without window

⑰ UserForm

⑱ Access Window Registry

⑲ Access SQL database

⑳ On Error