ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   labels in activesheet (https://www.excelbanter.com/excel-programming/389168-labels-activesheet.html)

Monte0682

labels in activesheet
 
I have 10 labels in active sheet.

I have 10 labels in user form. I would like to assign a colour to
every label in active sheet to be the same as the color in user form.

ActiveSheet.ele_1.BackColor = form_main.ele_1.BackColor

what I need to do for 10 labels

I think:

For i = 1 To number_of_elements
ActiveSheet.Label("ele_" & i).BackColor =
form_main.Controls("ele_" & i).BackColor
Next i

but it didn't work... Any suggestions?

Also these labels are shown in design mode only. when I exit design
mode I can't se any labels



All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com