Ok. uploaded the changed workbook.

Can you please send me the vba code to display the whole address instead of only city in the textboxes depending upon the postcode and house number please. The database needs to be access?
No, I can't.
Like dominic said, it's not possible to display 2,5++million addresses in excel
Thus, if you want to extract a complete address with only a postcode and a housenumber to go on (enter), you'd still get multiple hits, as many housenumbers are the same within a single postal-region.
That would be IF you had a database containing all this information.

and even then, II assume there are also many addresses througout the UK with exactly the same names in them, thus ever-changing streetnames due to new buildings etc. etc.so it would be a database that'd be "impossible" to maintain unless you have a fulltime job in the postoffice, doing just that :-p