View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Green[_2_] John Green[_2_] is offline
external usenet poster
 
Posts: 58
Default Table from labels

If you dim an array as labels you ned to refer to it as labels, not label (an array is not like a collection)

Dim labels(5)
labels(0) = Label1.Caption
labesl(1) = Label2.Caption

--

John Green - Excel MVP
Sydney
Australia


"T.K Kullervo" wrote in message ...
I want to refer to many labels inside a for loop. Is it possible to make a
table from the labels like labels(5)? I tried
Dim labels(5) as label
label(0) = Label1.. And so on

How is it done right?