Special Notice

On entering the Learning Centres of the School of Continuing and Professional Studies of The Chinese University of Hong Kong (CUSCS), all students and visitors are required to:

 

  1. Scan the LeaveHomeSafe venue QR code using the LeaveHomeSafe mobile app;
  2. Present their Vaccine Pass to show they have complied with the vaccination requirements.

 

You are also required to (i) Wear a face mask; (ii) Perform temperature screening, and; (iii) Use hand sanitizer. If you have a fever, feel unwell or are undergoing compulsory testing without proof of a negative nucleic acid test result, please refrain from coming to the Learning Centres. Thank you for your co-operation.

Close
Main content start

System Development & Programming

Excel VBA Programming
EXCEL VBA程式編寫

Course No. : 222-119260-02|Start Date : 01/09/2022

Admission Requirements

Participants are expected to have good knowledge in Excel and basic knowledge in programming.

Instructor

CUSCS Instructor

Language Used

Cantonese (supplemented with English)

Total Hours

15.0 hour(s)

Session

5

Place

Central Learning Centre

Start Date

01/09/2022

Schedule

Thursday

Time

18:45 - 21:45

Tuition Fee

HK$ 2,150.00

Level

General Short Courses

Course Enquiries

3943913127708275[JavaScript encoded]

Enrolment Enquiries

2209 0290

Closing Date for Application

Enrolment deadline is 10 calendar days before the course commencement date. Late enrolment will only be considered if there are still vacant places.

COMMENCED

1
Introduction

Visual Basic for Applications (VBA) the macro programming tool in Microsoft Excel for developers to create sophisticated user-oriented applications for automating tasks like data analysis. Topics include:1) Getting start with recording macros; 2) VBA Programming fundamentals; 3) Creation of specific user forms; 4) VBA interaction with charts; 5) Data analysis in Excel; 6) Case studies

2
Related Courses

Please click this link for related courses information.