Multiple labels on userform 2 update

[pswanie]

I got label1 to label100 on userform2. What would be a code to get them
update wen userform open?
2nd Q what/where would the code go to display the caption? Each label
reference to a diffrent cell. Would i put anything in the code module or just
something in the property?

 

[Keith74]

If you're using 100 labels something is wrong, maybe a gridview
control would be better.

Anyway you put the code to update the labels in the
Userform_initialize event.
To set the caption: label1.caption = "put caption here"

 

[pswanie]

Gridcontrol? Is that were u got a grid looking like a spreadsheet on the
userform? Will the userform work on any machine that i email it to? I got a
inventory control in a workbook. On one sheet user enter the items sold and
on a nother the closing stock so as to see a varianc for the day.