Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what object var should I use for the following code
I recorded the following code for adding a scrollbar to a sheet.... no
problem. So I cut and paste the code into my module and it runs fine. However what I can not figure out is what OBJECT varriable I can use with this statement so I can use the object varriable in the WITH END WITH cinstruct so I can reach and change different properties of the control. ActiveSheet.OLEObjects.Add(ClassType:="Forms.Scrol lBar.1", Link:=False, _ DisplayAsIcon:=False, Left:=cw * 5, Top:=7, Width:=15#, Height:=289 _ ).Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete object code | Excel Discussion (Misc queries) | |||
Chart Object VB Code | Charts and Charting in Excel | |||
Code to different object models | Excel Programming | |||
Programming code to new object | Excel Programming | |||
HELP! Object specific Code | Excel Programming |