ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   fill a shape with pictures based on the shapes boundries (https://www.excelbanter.com/excel-programming/426479-fill-shape-pictures-based-shapes-boundries.html)

pacsol_mic[_2_]

fill a shape with pictures based on the shapes boundries
 
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.

joel

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.



All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com