View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default fill a shape with pictures based on the shapes boundries

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.