Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
CHANGING FONT SIZE | Excel Programming | |||
Changing the font size in the charts | Excel Programming | |||
Changing font size in a list box | Excel Discussion (Misc queries) |