define row/column vector of matrix

[Ms.Sigma]

Hello all,

In user form, there are some textboxes and they display expected values derived from some other functions. After I get all these values, I need to use them to do further calculation.

For example, there are 5 textboxes, thus, there are 5 values. I need to make these 5 values to be a one row vector or one column vector. How should I define it?

Thanks a lot!!

 

[Ms.Sigma]

Now, forget all above discussion.

The new question is:

The listbox1 of user form displays several columns and rows. Now, I need all these data of listbox1 to do further calculation. For example, there are 3 columns and 3 rows. It is a 3X3 matrix, and we call this matrix M. Now, I am going to write a new function, and M is needed for this new function. Such as:

Function calculation(M,P)

dim p as variant
dim M

M=listbox1.list()

(definition of p is omitted here)

End Function

I think my definition of M is wrong. What is the correct way to refer the values of listbox?

 

[MickG]

Not quite sure what your trying to do , But this Commandbutton code passes the "Listbox1.list" to the function Calculation, Which returns the Sum of the ListBox values.

Private Sub CommandButton3_Click()
MsgBox Calculation(ListBox1.List)
End Sub

Function Calculation(M As Variant) as integer
Calculation = Application.sum(M)
End Function

Mick