Hi... been a while since i've posted here so Welcome back me!

I got a question for you all, I have about 30 labels on a userform an
I want my userform, on initilize, to fill those labels with values fro
the spreadsheet.

I'm hoping I can set up a small loop to do this and I guess my rea
question is How can I loop through 30 labels?

Would probably look like:

Dim LblName as object
dim i as integer


set lblName = userform.controls("label" & LblNumber)

for i = 1 to 30
lblname.*caption* = worksheets("sheet1").cells(1, *i*).value
next i



Any help would be great.. I have a lot of labels and a loop will mos
deffinatly help here

--
justchri
-----------------------------------------------------------------------
justchris's Profile: http://www.excelforum.com/member.php...nfo&userid=889
View this thread: http://www.excelforum.com/showthread.php?threadid=39802