Lecture 11

28 Novembro 2018, 09:30 • José Pedro Gaivão

Variables in VBA: data types, scope. 

InputBox and Msgbox.

VBA functions.

---

Computer Lab 7

23 Novembro 2018, 09:30 • José Pedro Gaivão

Exercise sheet Part III: VBA

---

Lecture 10

21 Novembro 2018, 09:30 • José Pedro Gaivão

Event procedures

Form & activeX controls

Objects: application, workbooks, worksheets, ranges, charts

---

Computer Lab 6

16 Novembro 2018, 09:30 • José Pedro Gaivão

Exercises in Excel:

- Part II

---

Lecture 9

14 Novembro 2018, 09:30 • José Pedro Gaivão

Introduction to VBA

- VBA editor

- recorded macros

 

---