Not sure this is even possible, vba code with an alert.

[DelusionalTuck]

So I just want to know if this is possible. Not sure how it would work.

I have a form for entering customers and a form for entering invoice details.

What I want is when I select the customer on the invoice form, which is in a drop down, that I get a message box with the miles and time from our shop to the customer.

I currently us google maps and do it by hand.

Was wondering if it could be automated.

Thanks Tuck,


I love learning.

 

[RedBeard]

This might point you in the right direction: https://www.reddit.com/r/excel/comments/22qf1y/a_function_that_uses_google_maps_api_to_find/

 

[DelusionalTuck]

thanks red,

I will play around with it.

Tuck