Excel Pro Education

Master in Microsoft Excel VBA

Enquire Now

Course Information

Schedules
  • 8 Oct 2022 (Sat) - 15 Oct 2022 (Sat) 10:00 AM - 5:00 PM
Registration period
1 Sep 2022 (Thu) - 7 Oct 2022 (Fri)
Price
HKD 3,290
(【 原價$4,990 】限時優惠!$3,290)
Course Level
Study Mode
Duration
12 Hour(s)
Language
Cantonese
Location
香港銅鑼灣軒尼詩道423-425號 嘉年華商業大廈
65 views

Course Overview

Master in Microsoft Excel VBA

Master in MS Excel VBA 大師級商務課程涵蓋所有在工作中需要的多重函應用 (Functions Nesting) 以及程式編寫 (VBA Macro)。內容完全涵蓋各專門行業的 MS Excel應用,令你在工作上邊得更專業,更強大!

本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解MS Office各版本的特點。由1997年的紮實基礎到Office 365版本的最新技術,都能夠靈活運用。

所有學員完成 12 小時的課程後將能夠熟練地運用 Excel 在工作中所需要的 VBA Macro 全自動程式的編寫,理論及商業應用等的 Excel VBA 學習重點。

歡迎到本電腦中心的網上報名系統報讀以上課程,網站連結: https://www.ExcelProEdu.com.hk

如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡!

What You’ll Learn

課程內容:

VBA Layout and Background

  • Excel Macro, VBA, VBE?
  • Why do we use Macro and VBA?
  • Why do we need VBE
  • VBE Layout
  • How to setup the VBA Layout
  • What is Modules
  • VBA Code basic structure


The VBA Language Background

  • What is a computer language
  • What is an algorithm?
  • The Object Oriented Language
  • The Object-Method Model
  • What is an Object in Excel?
  • What is a Method?
  • How to call an object and apply a method?
  • The Excel Object Hierarchy


The VBA Language Structure and Syntax

  • VBA BASIC
  • Option Explicit
  • Declare Variables
  • Variables Types
  • VBA Operators
  • MsgBox
  • With
  • If…Then…
  • If…Then…Else…
  • If…Then…ElseIf…Else…
  • For Loop
  • For Each…In…
  • Do While Loop
  • Do Until Loop
  • Exit Do
  • Application.Run
  • Cell Reference
  • Range
  • Cells
  • Range.Active / Range.Select
  • Range.Offset
  • Range.End
  • Range.CurrentRegion
  • Application.Goto
  • Range.Font
  • Range.Interior.Color
  • Range.Borders
  • Clear and delete a range of cells
  • Range.Value
  • Range.Text
  • Range.Formula
  • Range.Delete
  • Range.copy
  • Range.Copy Destination:=Range
  • The VBA Language Structure and Syntax
  • VBA BASIC
  • Add new worksheet
  • Delete a worksheet
  • Copy worksheet
  • Move a worksheet
  • Get the worksheet name
  • Close a workbook
  • Save a workbook
  • Show file path
  • Macro that runs when open the workbook
  • Macro that runs before closing the workbook
  • Charts
  • Add a chart
  • Add a chart with positions
  • Change Chart type
  • Set Chart Title
  • Set Axis Title


Forms

  • Build a form
  • Show the form
  • Build a button to show the form
  • Close the form
  • Write text on the form
  • Build a text box for user input
  • Create a operation button
  • Radio buttons
  • Check boxes
  • Drop menu
  • Get the value from the drop menu

 

歡迎到本電腦中心的網上報名系統報讀以上課程,網站連結: https://www.ExcelProEdu.com.hk

如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡!



Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed