Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 text labels in category axis - missing labels Boris Charts and Charting in Excel 3 December 5th 08 04:33 PM
How do i create labels so, could only move and type in labels only kloniki Excel Discussion (Misc queries) 1 April 12th 08 06:04 AM
Icons __AND__ labels?! How do I get rid of toolbar LABELS! shamblinthru New Users to Excel 2 March 19th 07 09:19 PM
Copying new activesheet after other activesheet is hidden? Simon Lloyd[_790_] Excel Programming 1 June 20th 06 10:02 AM
Excel 2003 and Labels (NOT Address Labels) Los Excel Discussion (Misc queries) 2 May 4th 05 01:57 PM


All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"