Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am adding a textbox and trying to set its properties using VBA. I get the
box but cannot figureout haw to set the properties. Here is part of my code: ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextB ox.1", Link:=False, _ DisplayAsIcon:=False, Left:=500, Top:=690, Width:=30, Height:=18). _ Select With Selection .Placement = xlMoveAndSize .PrintObject = False End With ' I want to set the properties of textbox1 here, ' but do not know how to do it. Need to set LinkedCell and Value. Your assistance is appreciated. Thank you. -- Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing textbox properties from Access VBA | Charts and Charting in Excel | |||
Properties transferring from excel cells to word file properties | Excel Programming | |||
Textbox Properties questions | Excel Programming | |||
Copy range Cell text and font properties to a Textbox | Excel Programming | |||
TextBox Properties -- Don't move and size with cells | Excel Programming |