Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 313
Default changing font size in an activex label

This fragment of code i am creating a lable, but when I attempt to change the
font size in the WITH BLOCK. Could someone point out what I am doing wrong.

Set control = OLEObjects.Add(ClassType:="Forms.Label.1", Link:=False, _
DisplayAsIcon:=False, Left:=cw * 3, Top:=rh * 2, Width:=cw * 6,
Height:= _
rh)



With control


End With
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default changing font size in an activex label

control.Object.Font.Size = 20

--
Tim Zych
SF, CA

"TONY" wrote in message
...
This fragment of code i am creating a lable, but when I attempt to change
the
font size in the WITH BLOCK. Could someone point out what I am doing
wrong.

Set control = OLEObjects.Add(ClassType:="Forms.Label.1", Link:=False, _
DisplayAsIcon:=False, Left:=cw * 3, Top:=rh * 2, Width:=cw * 6,
Height:= _
rh)



With control


End With



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
Changing the font for part of an axis label, not the whole label. amy45 Charts and Charting in Excel 2 April 5th 23 01:11 PM
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
CHANGING FONT SIZE gwbdirect Excel Programming 3 September 12th 07 10:40 PM
Changing the font size in the charts navin Excel Programming 1 April 13th 07 01:16 PM
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 04:07 PM


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