![]() |
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