Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I used the following line to add a label (or textbox, etc.) to my worksheet,
and I can see it in Excel. Excel.OLEObject ole = ((Excel.OLEObjects)wsTemplate.OLEObjects(Missing.V alue)).Add("Forms.Label.1", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, 15, 15, 100, 20); The problem is that it just says "Label1" for the text. How can I go about changing it and the font as well? I can't figure out how to cast the ole.Object to anything which is what I think I need to do. I've see lots of VBA code that just uses "With" as below, but can I do something similar in C#? Dim Lbl As OLEObject Set Lbl = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Label .1", Link:=False, _ DisplayAsIcon:=False, Left:=232.5, Top:=241.5, Width:=72, Height:=18) With Lbl .Name = "ttt" .Object.Caption = "p.sub new control" .Object.Font.Bold = True .Object.BackColor = RGB(255, 0, 0) End With Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object properties viewer | Excel Programming | |||
Error on fetching object in OLEObject | Excel Programming | |||
Get OLEObject.Object with Csharp | Excel Programming | |||
Word Art Object properties in VBA | Excel Programming | |||
iterating through all properties of an object | Excel Programming |