Format Cells for UK Postcode

Hi Mike

In reply to your post #14

The first code goes into a standard module as you have correctly done

The second block of code goes in the sheet module for the sheet you want to control
Right-click on the sheet tab of the relevant sheet and select > View Code
Paste the second block of code in the resultant window.

You need both modules to make this work

See this example

1/. Select the Country from the Drop-down in column K and run see the change in column J

2/. Copy column A back into column J, this time select the country and run the macro "CheckPostCodes".

Hope this helps

P.S. I have slightly changed the function "FormatPostCode" to ensure that uppercase is returned