Returning to INdexing labels and coloring them by group
Posted on 2004-10-26
A couple of days ago I asked about how to give all labels on a form the same background color. I received 2 excellent replies; unfortunately, one of them does not work for excel.
It is this one
Pub sub command1_click()
Dim i as integer
for i = 0 to Userform3.label1.ubound
The problem seems to be that it will not let me see or create an indexed label with the same name.
dim a as label 'works
but I cannot put anything on the form with the same name and if there is a way to create and use an array of labels I surely don't know how to do it.
Vinnyd79 if you are around, this was originally your code.