Educational links

Arrays are a single programming variable that have multiple compartments. It is like opening a single draw that has been divided into numerous compartments to store various items.

Conditional statements are statements or expressions that are only executed if a certain condition is meet. ie. If the condition is true then do something. 

Example: If X > 10  Then MsgBox("This number is greater than 10")

In VBA condition statements can be written as IF statements or as Select Case statements.

Random number Generator

Two simple VBA scripts to generate random numbers

Make a simple splash form using VBA Code

An Excel guess number activity

Copy and paste the VBA code into an Excel Macro. Run the macro and see if you can beat the teacher!

Hidden within the matrix is the answer.

User login