I'm working on this some today. I'm going to add the auto calculation for distance first, then I will post where i'm at. Then try to clean it up some.

I have a question though. I have made another module for another sheet in the workbook. It runs correctly if I assign it to a button and click it. However, when I try to call that module in the zipcode_change handler I get an expected procedure not module error.

[VBA]Private Sub zipcode_Change()
'Run Zip2Zip calculation
Call ZIP2ZIP
'Import Distance Calculation
akrondistance = [Main!C2]
ftwaynedistance = [Main!C3]
rockforddistance = [Main!C4]
stlouisdistance = [Main!C5]
End Sub[/VBA]

Do I just need to run the code straight from the event handler instead of using it as its own macro?