I have a worksheet named Miles. I also have a Userform that asks the user
for Start Location and End Location then what i want it to do is have it
query google maps for specific miles and import that finding into cell C2
then if they press New Location (Commandbutton1) it resets the form and puts
the new data in C3.

Any Idea how to do that?

"Chip Pearson" wrote:

What distance do you want to measure? Driving distance? Great circle
distance? I have a workbook on my web site that lists the latitude and
longitude of about 1200 cities in the US and it has code and formulas for
calculating the great circle distance (shortest distance) between two
cities. See http://www.cpearson.com/Excel/latlong.htm for details and
download the workbook at http://www.cpearson.com/Zips/LATITU~1.ZIP .


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Ewing25" wrote in message
...
Is there anyway to find the miles between the 2 places that are inputted
into
2 different cells?

for instince if Los Angelas, CA is inputted into cell 1A and New York, NY
is
inputted into cell 1B it will automatically put into cell 1C the miles
between them.

Is there anyway to do this?

Thanks