Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
How do i create labels so, could only move and type in labels only | Excel Discussion (Misc queries) | |||
Icons __AND__ labels?! How do I get rid of toolbar LABELS! | New Users to Excel | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
Excel 2003 and Labels (NOT Address Labels) | Excel Discussion (Misc queries) |