Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate quantity of shapes inside another shape jlclyde Excel Discussion (Misc queries) 8 July 9th 11 06:00 AM
Can I use VBA to assign Macro to Shape within a Group of Shapes? MikeZz Excel Programming 1 January 28th 09 01:25 AM
Add and delete pictures and shapes jlclyde Excel Discussion (Misc queries) 2 October 22nd 08 02:54 PM
How to update Shape pictures tiamat Excel Programming 1 January 28th 08 09:29 AM
VBA Help with changing shape color for selected shapes only Nimrod[_2_] Excel Programming 8 April 29th 05 01:38 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"