Hello to everyone, I have latitude and longitude coordinate. This is in degrees minutes format, I have to decrease 15 minutes in latitude coordinate and increase 15 minutes in longitude coordinate. I need the code in the vba function ex."Function Convert_Latitude(Lat As String) As Double" "Function Convert_Longitude(Long As String) As Double"
If you help me, I will be grateful to you.
Last edited by angelinabrown0123; 12-19-2020 at 12:26 PM.
Do the functions Convert_Latitude and Convert_Longitude already exist or are you looking to create them?
If posting code please use code tags, see here.
vba function actually does not exist, I have shown it to be created like this
The main problem I see is that all of your inputs and outputs are text. So your overall procedure needs to parse the text string into a meaningful number, perform the calculation, then convert back to a text string. Perhaps it is just my own bias, but I hate converting numbers to text, so I try to avoid that as much as possible.
What is absolutely required here and what can we do differently? Are you required to store the coordinates as text strings in this format, or are you allowed to find other ways to store these? Are you required to use VBA, or would a worksheet formula solution be acceptable?
Here's how I would probably do this (which is not exactly what you show, but I find it easier):
1) Store numbers as degree.decimal minute numbers. 16.45 -- 80.45 and 15.23456 -- 79.45321 and so on.
2) Use the DOLLARDE() function to convert these to decimal degrees DOLLARDE(A3,60)
3) Perform the addition/subtraction latitude -- DOLLARDE(...)-0.25 longitude DOLLARDE(...)+0.25.
4) Convert back to degree.decimal minute numbers using the DOLLARFR() function. In D3 =DOLLARFR(DOLLARDE(...)-0.25,60). In E3 =DOLLARFR(DOLLARDE(...)+0.25,60). Copy/paste/fill down.
Would something like that be allowed?
Originally Posted by shg
If you search you'll find plenty of functions that convert between degrees latitude/longitude and decimal latitude/longitude.
The only issue is that you'll have to find functions that will work with the format you are using for degrees.
MrShorty, This would be possible with vba, so it would be good because I don't like to calculate in many rows, if it is difficult by vba then I would not mind the formula either. And I also tried using the given =DOLLARFR function but it is not responding correctly every time, maybe I made a mistake in calculating..
It is difficult to debug without knowing exactly what you tried. My guess is that some of the input values were not entered correctly, but there's no way to know without knowing exactly what you tried.I also tried using the given =DOLLARFR function but it is not responding correctly every time,
I'm not sure I understand the preference for VBA. If you can enter the data as degree.decimal minute like I suggested, the same sequence can be executed in VBA by calling the Excel functions from VBA, but I don't see what advantage the VBA function would provide in this case.
Unorthodox method perhaps?
Please Login or Register to view this content.
Last edited by sintek; 12-20-2020 at 04:54 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Yes this is what i was looking for but it is possible in vba (formula) function
It is in VBA ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I had cleared in the first post that this answer may be necessary in the vba formula, There is no reason to be confused, you may not have understood me or you have not read the first post.,
It is in VBA ...
Although I like the effort of MrShorty and sintek.
There is one very good reason to be confused, and that is that you have posted in the VBA section. If you don't want a VBA solution, then that is your mistake!
Would you like me to move the thread to the correct forum section for you?
UDF ?Yes this is what i was looking for but it is possible in vba (formula) function
Please Login or Register to view this content.Formula:
Please Login or Register to view this content.
Copy down and across
Last edited by sintek; 12-20-2020 at 05:34 AM.
I think the OP wants a formula, but posted in the wrong area. Let's wait for a response to post #12.
No formula options available...As data is text...
Could we all please wait now until the OP has responded to my post #12? Thanks.
Not true ... It is possible.No formula options available...As data is text...
Last edited by AliGW; 12-20-2020 at 05:51 AM.
Okay, cool...Formulas not my forte...
Assumed this is UDF?I need the code in the vba function ex."Function Convert_Latitude(Lat As String) As Double" "Function Convert_Longitude(Long As String) As Double"
Last edited by sintek; 12-20-2020 at 06:00 AM.
@Sintek - see posts #9 and #11.
I have very clearly requested that you do NOT post again to this thread until the OP has responded to my post #12. Please do not ignore this request!
I have a potential formula solution ready, if required.
Last edited by AliGW; 12-20-2020 at 06:40 AM.
All Participants:
Please do not post a reply in a thread where a Moderator or Administrator has requested an action that has not yet been complied with (in this case, a response to post #12). Thanks.
I apologize for the late reply, I tried your function, it's absolutely accurate, I wanted it, thank you for your effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks