VBA Programming assistance required

I have a spreadsheet as attached which has a glitch in the programming.

There are 3 drop down boxes within the form which reference Country, County and Local Authority.

From selecting which country is relevant this should in turn give a list of counties which are only available to that choice and then the same based on the choice of county for local authority.

This was all working until i made some modifications to the form to include tender details and dates.

Could someone please review this and either let me know what I've done wrong or correct the issue.

For the benefit of anyone reviewing this, there is meant to be blanks above each list so that the drop down can be reset back to nothing.

Your code references a sheet named

"tender info verification"

which no longer exists in your workbook. Perhaps you re-named it, in which case you need to correct all your code to the new name.

Note that it is often better to use the sheet object's codename rather than the text on the tab - for example, the sheet "Country" is Sheet2, so instead of using

Worksheets("Country").Range.....

you would use

Sheet2.Range.....

You can modify the sheet object's codename in the properties window to give it a meaningful codename, like "shtCountry". Then, if you decide to rename a sheet on its tab, doing so will not affect your existing code.

Your "County" dropdown has the wrong macro assigned (23, not 25), and the Local Autohority dropdown should not have any macro assigned.

Great! Happy to hear it, and thanks for posting back.