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 (or any other program/process that will do this) 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. But if they press Done it ends the Macro.

Any Idea how to do that?

Thank you!
Alex