coordinates

Hi, I have been trying to set a grid of 50 cells x 50 cells and use the Shapes.Addline method to draw lines on it using coordinates that relate to that grid. I think I understand the coding but am not clear how Excel decides where to draw the line on my screen. For example if I use...

Hi Team, I have an requirement where i need to move the mouse cursor to to particular element on the screen. I tried to look the code but only able to find the code by setcursorposition where in you need to have the coordinates. Is there any possibility that we can move mouse cursor without...

If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...

Facing problem with positioning User Form on screen as it goes to the left top Corner. I want it in center or as per my coordinates?

Hello everyone. The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for: Rows Per Group Columns per Group Starting X-Coordinate Starting Y-Coordinate Starting Z-Coordinate Rectangle Width Rectangle Height...

Hi there, I have a list of coordinates (latitude, longitude) which I've plotted on excel 3d map. I've also imported a .kml file into my file which shows regions within the same country. How am i able to filter the coordinates or color code them based on whether they fall within the regions...

Dear forum. I have made an Excel sheet, where I entered (copy-pasted) gps coordinates from Google Maps. The column settings in Excel were not adjusted from the beginning, because I couldn't seem to find the right setting. This means that the current format is e.g. 55.419.474 10.455.039 and...

Hi, right now I have a spreadsheet like this: A | ​B 1 | 2 2 | 2 1 | 5 2 | 2 1 | 2 3 | 4 I want to return the number of duplicate coordinates for each coordinates. So an EXCEL VBA function that loops...

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)? In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what...

Hi All, I have a spreadsheet with a long list of Lat & Lon coordinates which I need to calculate the distance and bearing from a base point. I have tried many formulas, some from this site and some from other sites, but nothing seems to work. I don't know if it is the format of the...

I would like to ask “SHG” a question as it relates to an old post of his, namely: https://www.excelforum.com/excel-formulas-and-functions/927663-3d-coordinate-translation-and-rotation-formulas-for-excel.html This was a very nice solution to the posted problem, however I also saw this as a...

I have a list of coordinates (columns B and C) of agencies (rows) that are associated to a zone (column A). I attached a screenshot of a reduced list as example. In cell D2 of the example I put a formula that calculates the distance between coordinates in row 2 and row 3...

Consider this two point on the map: <tbody> latitude longitude 45.61782 9.41737 45.48568 9.20181 </tbody> The distance between each other is about 22km. What's the formula to calculate that? I tried different formulas found online but every one returned absurd values...

Hi, I was wondering if there is a way to get the slicers buttons to be manipulated by position, so they will not act as a list, and keep in line. I wish to control the XY coordinates of the slicer button inside the slicer box. is that wishing too much? Best Regards, S.

Hi I have a worksheet that lists physical locations and 2 respective columns that display the latitude and longitude coordinates for the location in that row. I am trying to automatically generate a respective URL in the cell adjacent to the coordinates columns that displays the complete URL...

I have two lists of coordinates, X,Y,Z. One list is significantly longer than the other as has additional non matching X,Y values. The Z values are purposely different. At the end of the day I want to compare the different Z values between matching X,Y coordinates What I want to do is find the...

Hello, I am sorry for my bad English. I am a student from Germany and I have the following problem: I am doing a Master which is in fact a combination of Humanities and Computer science. I did a Java course but last week we have received several exercises about VBA Excel, without having a...

Good grief, this shouldn't be as hard as it's been for me. I'm just not as well-versed with the INDEX/MATCH stuff, so I'm stuck with the syntax here. Got a column with a bunch of dropdown menus, data validation already set up there and all that. I need cells in a separate column to give me the...

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