VBA is Easy

 

1. VBA Introduction
1) What is VBA
2) Main functionality
3) VBA security concern
4) Steps of problem solving for programming

2. VBA in Excel
1) Enable VBA in Excel
2) Recording VBA
3) Save VBA code
4) Run and edit macro
5) Assigning a macro to a sheet item

3. Editor of VBA – Integrated Development Environment (IDE) Introduction
1) Project Explorer
2) Properties Window
3) Code Modules
4) Watch Window
5) Options

4. User Defined Function (UDF)
1) Examples of how to write UDF
2) Using functions in VBA

5. Loops and logic
1) For … Next
2) For … Each
3) Do While …
4) Do Until …
5) Case

4 Comments

  1. 老师讲得很好,逻辑很清楚. 不过vba可能mac和window系统不同,上课的时候有些short cut 需要自己转化到mac上应用,会耽误时间然后miss老师后面的内容.

Leave a Reply

Your email address will not be published. Required fields are marked *