UK post code calculator

Hi guys,

I need to calculate the distance between a list of UK postcodes...

I have found a macro which does it, but you have to manually enter the two postcodes and then it will populate the distance data on the sheet.

See the attached file as to what I am working with...

Now what I want it to do, is automatically calculate the distance based 2 coloums on the excel sheet... so I don't have to manually enter the information and perform the calculation 1 by 1...

is there anyway I can make the macro automatically populate the input postcodes into the user form based on a list of cells with those values in?

Thanks very much