Hi,
I am hoping someone can help me out here.
I have 53 Label captions on a userform. These pick up their value from cell on sheet 1.
IE Label1.gets data from cell A1
Label2 gets data from cell A2
Is there a way to loop through to assign value to all 53 labels without having to code each one?
If the cell from which the data is taken contains "NO DATA" the back color of the label needs to be set to grey.
There must be a simple way to code this without have to write 106 lines of code.
Any Help appreciated.
Regards
Mark.
Bookmarks