Something like this

Dim ary()

Private Sub CommandButton1_Click()
Static counter As Long

counter = counter + 1
ReDim Preserve ary(1 To 2, 1 To counter)
ary(1, counter) = lblA1.Caption
ary(2, counter) = lblA2.caption
ary(3, counter) = lblA3.caption
ary(4, counter) = lblB1.Caption
ary(5, counter) = lblB2.caption
ary(6, counter) = lblB3.caption
ary(7, counter) = lblC1.Caption
ary(8, counter) = lblC2.caption
ary(9, counter) = lblC3.caption

End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gti_jobert" wrote
in message ...

Hello,

I have a userform with 9 labels;

-lblA1, lblA2, lblA3
-lblB1, lblB2, lblB3
-lblC1, lblC2, lblC3

and on the same userform i have a button, when the user clicks it i
want all the values from the labels to be stored into an array NB. the
user may press the button max times 6 - thus everytime the button is
pressed 9 variables are stored into the array and if the button clicked
6 times then 54 would be stored.

Any Ideas? I'm not so good on 2d arrays


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=507286