Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
I have a label on a worksheet (which I added using the Control Toolbox toolbar). I don't know if it's an ActiveX control or not. I want to programatically change the label's Font. The following code doesn't work with the error message:- Object doesn't support this Property or Method ActiveSheet.Shapes("Label1").Select Selection.Verb Verb:=xlOpen Label1.Caption = "Accounts" With Selection.Font .Name = "Arial" .FontStyle = "Bold" .Size = 13 End With I presume it's the syntax that's wrong. Any suggestions would be appreciated. -- donwb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
Font in Userform | Excel Programming | |||
change display font to actual selected font | Excel Discussion (Misc queries) | |||
Userform-Change textbox color and font based on input in other tex | Excel Programming |