Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Position
A while back Dave Peterson help me with the following code.
With ActiveSheet Set myShape = .Shapes.AddShape(Type:=msoShapeOval, _ Top:=HalfHeight, Left:=HalfWidth, _ Width:=myShapeWidth, Height:=myShapeHeight) myShape.Name = "shp" & Format(Now, "yyyymmdd_hhmmss") This is part of routine that will place an autoshape at a pre-determined screen position, and it works great. However, I have not been able to figure out a way to place a Picture (clip art) or WordArt textboxes. I have worked with Set myShape but am not getting anywhere. Any help is appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Position
look at the AddPicture method of the Shapes Object in excel VBA help. Pretty
much just add a few addtional arguments related to the picture in module put in Activesheet.Shapes.AddPicture highlight the AddPicture and hit F1. -- Regards, Tom Ogilvy "Ronbo" wrote: A while back Dave Peterson help me with the following code. With ActiveSheet Set myShape = .Shapes.AddShape(Type:=msoShapeOval, _ Top:=HalfHeight, Left:=HalfWidth, _ Width:=myShapeWidth, Height:=myShapeHeight) myShape.Name = "shp" & Format(Now, "yyyymmdd_hhmmss") This is part of routine that will place an autoshape at a pre-determined screen position, and it works great. However, I have not been able to figure out a way to place a Picture (clip art) or WordArt textboxes. I have worked with Set myShape but am not getting anywhere. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fix the position of an object on the screen? | Excel Discussion (Misc queries) | |||
Position drawing object relative to cell | Excel Discussion (Misc queries) | |||
lock position of Word object in protected excel spreadsheet | Excel Worksheet Functions | |||
Line Position Drawing Object | Excel Programming | |||
Data Label Object Position not working | Excel Programming |