MatrixValue

concerns

The MatrixValue attribute function determines a value of a cell of the matrix.

 

Syntax

MatrixValue(X, Y)

Return value

Variant

Parameter

Use

Name

Type

Passing

Description

Required

X

Variant

ByVal

Value used to find a column in the matrix

Required

Y

Variant

ByVal

Value used to search for a row in the matrix

 

Example:

The following matrix is defined in a class:

 

 

 

MsgBox(Matrix1.MatrixValue(20, "B"))

#Shows 200

 

MsgBox(Matrix1.MatrixValue(20, "A"))

#Shows 500 (cause the cell is empty -> Default value)

 

MsgBox(Matrix1.MatrixValue(20, "K"))

#Shows 0 (because no cell is created for this combination of values -> no hit)