Lab 12

13 Dezembro 2019, 09:30 • José Pedro Gaivão

VBA exercise sheet.

---

Lecture 12

11 Dezembro 2019, 09:30 • José Pedro Gaivão

Sintax of procedures: sub and function; arguments: byVal, byRef

Conditional structures: if then else; select case

Loop strucutres: Do while, Do until

Arrays

---

Lecture 11

6 Dezembro 2019, 09:30 • José Pedro Gaivão

Variables data types and scope. Examples. 

Common VBA functions. 

MsgBox and InputBox. 

---

Lab 11

4 Dezembro 2019, 09:30 • José Pedro Gaivão

VBA exercise sheet.

---

Lecture 10

29 Novembro 2019, 09:30 • José Pedro Gaivão

Common methods and properties VBA objects: Application, Workbooks, Worksheets, Charts, Range. 

Examples.

---