coordinates

Hello, I'd like to construct variable-length polygon arrays, which contain a set of points given their coordinates. Each point has two coordinates (x, y). Eg.: poly001 = [ (x1,y1); (x2,y2); ... (xn, yn) ] where (x1,y1) ... represents the first point in 1-dimensional array. I'm also thinking...

Hi Dear Friends, Does anybody know how I can use VBA to get the coordinates of a point using a GPS or a Satellite? If Access/Excel cannot do this on their own, probably there is an ActiveX control somewhere that can be plugged in? Thanks in advance Sam

I am using this formula =SLOPE('2012:2017'!$A$2,'2012:2017'!B61) to calculate the slope of a line. The sheets, 2012, 2013....2017 contains the data entry. The cell A2 in each sheet contains the x coordinates that are common and then B61 contains the first set of y coordinates that I want to...

Hello I have developed an VBA application that is able to get coordinates from Google API if user inserts address into the right cell. After finding coordinates it can find nearest another coordinates from another database. That all works well. Now if I tried my application in another computer...

hi, i have this table <tbody> START END Color x y x y red 0 0 0 1 red 0 1 1 1 blue 1 1 0 1 yellow 0 1 0 0 </tbody> It defines the start and end points and also the color of lines. How can we create a chart that draws these lines with the right color while more points can be added?

Hello everyone, I am trying to insert text boxes onto my chart based on the bar chart coordinates. I am not sure if this is doable. I am trying to loop through the series and select and based on that selection I need to find upper left and right corner coordinates of that bar chart so that I...

Hello All, Been desperately looking for a code snippet which i could use to list the position coordinates of all buttons used in a workbook. What i want is to list down the Sheet Name - Button Name - Button Height - Button Width - Button Top - Button Left in a new worksheet and append one...

I have a list of locations, with their coordinates, and I have a set of regions of which I have the coordinates of the border points. Now I would like excel to specify for me in what region every location is. I was thinking of using a nested IF function, but I have up to 20 regions so I am...

Hi all, I'm trying to find the coordinates of a textbox within vba. The textbox is within a user form and I'm sure there's a simple way to grab the coordinates but I've got no idea how to do it. Thanks in advance for looking over this! ZD

Hello, first time poster. I have a list of zip codes and their corresponding latitude and longitude points from the US census bureau. I was hoping this data could be used to determine if a given zip code fell within a certain radius of another zip code. In other words, if I could take the...

Hi, i have a list of coordinates (lat/LON decimal format wgs84) and i would like to find the extremity or perimeter points, i.e. to find the point that will define a polygon ignoring the inner points. Yossi

Hi all How are you? My problem is as follows: I guess it's better to explain my problem with an illustrated problem. I have some circles with radius of 5 meters, and some points that some of them are located in the circles. I want to find that which point is located in which circle. The...

So basically i am running this macro to generate the coordinates of certain points on a piece of material. However once the outer edge of the material (the breadth=1000) has been plotted i need the macro to stop running (leave cells unchanged). Also i was wondering if there was any way to...

Hello All, I am looking for a method of, having input a finite no. of XY coordinates in Excel 2010, to produce a shape (using straight connectors). I would then like the area of this shape to be calculated. Is there a method that I can use in Excel 2010 to do these? I have a rudimentary...

Hello, I am creating an application to model probability distributions, and I had an idea to allow the user to SKETCH probability distributions intuitively by clicking and dragging the mouse to trace the curve in an embedded chart object or chart window. I need to be able to get an array of XY...

Hello, How can I get coordinates for multiple selected cells? I know it is possible with one cell selected by using "selection.address". How would it work if I had more than one cell selected? Thank you!

Hi All, Following this recent question on creating mouse-interactive embedded charts (http://www.mrexcel.com/forum/excel-questions/697254-how-create-mouse-interactive-chartobject.html#post3451252), I have struggled to set up a class module with the mousedown event, because I have many sheets...

Okay I have used a loop to calculate values for x and y and displayed both in seperate columns. I have put x in a column starting f2 and y in a column starting g2 how then do i then input these coordinates to another formula. It is to calculate the angle of a robot arm, the formula is (x^2 +y^2...

Hi Please help me I need coordinates B download excel Book1.xlsx download - 2shared

I have been looking through a lot of very similar threads on this particular subject but have thus far been unable to find a solution that works for me. I imagine that there is something on these forums that would work but I figured it couldn't really hurt to try posting my own thread. I have...