Computer Lab 10

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

Development of a simple program in Excel/VBA to analyse Markov chains. 

---

Lecture 13

12 Dezembro 2018, 09:30 • José Pedro Gaivão

Arrays

VBA best practices

UserForms and controls

---

Computer Lab 9

7 Dezembro 2018, 09:30 • José Pedro Gaivão

Bank account VBA application

---

Lecture 12

5 Dezembro 2018, 09:30 • José Pedro Gaivão

Sub and Function

Scope: Public and Private

Passing arguments byVal and byRef

Conditional structures: if then else, Select

Loop structures: While, Until

---

Computer Lab 8

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

Exercise sheet part III.

---