Excel - Z Index

ISY

Active Member
Joined
Nov 16, 2009
Messages
430
Office Version
  1. 365
Platform
  1. Windows
Hello :rofl:

Any number of examples and comments.
You can check with shapes number 2, Z Index (Vba)

Thanks for any advice

Excel 2003
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hello

Thank you for your response, just yesterday I asked for advice from a C++ programmer
Who invited me to item Z Index
 
Upvote 0
Try explaining exactly what you want to do.

I have forgotten all the C++ that I ever knew (which wasn't very much).
 
Upvote 0
Hello

Explanation of my question:

I would like to draw two Shapes with Excel 2003 and then rotate them to determine if they overlap on the worksheet. (TRUE - FALSE)

Example 1: If you save the current image to disk I get a screen size but if I change the display order of overlapping shapes when the next changes the image size.

Example 2: I would estimate the distance by placing the connectors between the figures.
Example 3: I could read the color of each pixel on the monitor to determine their overlap (Problems in the API used Sheda video)

If I have to study trigonometry to solve?

Waiting for good advice
 
Upvote 0
OK , well my understanding is pretty poor but here goes:

ZOrder is related to the visibility of shapes (strictly how far back they are on an imaginary Z axis extending backwards from your view of the monitor). So in relation to their relative positions (X-Y) so this is a no no.

Each shape has Top, Left, Height and Width properties. You should be able to use these properties to determine whether they overlap.
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,716
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top