LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Change label border color at runtime


Is there any way to change a label's border color at runtime? I use the
following code to create two labels, one horizontal and the other
vertical. They are designed to make a cross symbol wherever I click on
an image control. This works great, but I need them to be red instead
of the default grey.

Set Lbl = Controls.Add("Forms.Label.1", "lblLabel" & NumAnnuli,
True)
With Lbl
..Top = Y
..Left = X - 6
..Height = 1
..Width = 12
End With

Set Lbl = Controls.Add("Forms.Label.1", "lblLabel" & NumAnnuli,
True)
With Lbl
..Top = Y - 6
..Left = X
..Height = 12
..Width = 1
End With


--
timspier
------------------------------------------------------------------------
timspier's Profile: http://www.excelforum.com/member.php...o&userid=32090
View this thread: http://www.excelforum.com/showthread...hreadid=521311

 
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
change border automatic color dseimr Excel Discussion (Misc queries) 0 February 20th 09 06:56 PM
border color does not change Mac Excel Worksheet Functions 2 January 3rd 07 03:05 PM
Border color doesn't change. Rusty Excel Discussion (Misc queries) 3 March 10th 06 05:43 AM
Change the border color used by Change Tracking Jim Stoaks Excel Discussion (Misc queries) 1 January 20th 06 09:32 PM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM


All times are GMT +1. The time now is 07:18 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"