Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have preset shapes that our defined by lines. i want the lines to define
the boundries of the shapes(pictures) i want to insert. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The lines and pictures uses pixels location to determine there positions.
the sttart and end points of the lines is an x and y corrdinate like (246, 529) and (246, 1024) This is a vertical line because the X corrdinate is the same. The pictures have 4 properties 1) Left 2) Height 3) Top 4) Width If the line is the left boundary of the picture then you want picture1.Left = 246 You want the height of the picture to be the length of the line picture.height = 1024 - 529 Note : Positive width goes to the right of the screen which is obvious. Positive Height got towards the top of the screen (which most people get wrong the 1st time). "pacsol_mic" wrote: I have preset shapes that our defined by lines. i want the lines to define the boundries of the shapes(pictures) i want to insert. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate quantity of shapes inside another shape | Excel Discussion (Misc queries) | |||
Can I use VBA to assign Macro to Shape within a Group of Shapes? | Excel Programming | |||
Add and delete pictures and shapes | Excel Discussion (Misc queries) | |||
How to update Shape pictures | Excel Programming | |||
VBA Help with changing shape color for selected shapes only | Excel Programming |