I need help creating a 3x3 Matrix in vba?

I am in a begginer programing course, i know how define a single line vector using:
Dim A as Variant
ReDim A (1 to 3)
A(1)=1
A(2)=2
A(3)=3

and then do calculations the the vector. The problem is i don't know how to do this to a matrix. The question asks me to make a function that passes the dimensions of a matrix and then multiplies the matrix by a scaler. Any help getting me started?