Using a combo box to open worksheets in a named range

[Barking_Mad]

Hi,

I'd like to have a combo box open a worksheet based on values in a named range. There are other worksheets in the same workbook id rather not have listed in the combo box, hence the use of a named range. Im sure this is easy but as try as I might i cant find exactly what i want on the interwebs.

Thanks

[Barking_Mad]

Please ignore I have done it. For anyone stumbling across this see below for code:

Paste into code for sheet containing data validation drop down list where A1 and $A$1 are the location of your dd list.

Please Login or Register  to view this content.

Paste the below into ThisWorkbook, where Sheet1 is the name of the worksheet containing your DD menu.

Please Login or Register  to view this content.