VBA not updating the dropdown list after sheets added.

I'd consider moving the initialize to the workbook level, and triggering it off of Workbook_NewSheet so that each new sheet that's added triggers an update to the list.

Please Login or Register  to view this content.

I see the issue:

You missed a letter in the copy and paste, and it's also in the wrong area.

Workbook-level code should be in the ThisWorkbook object.

I also added another block on the Sheet10(Select Type) object that will update when that tab is selected. This way the code will also run if you leave that tab to delete another.

Further to daffodil11 post,

here's another alternative, which is triggered when activating the sheet (put in the sheetmodule for "Select Type").

Please Login or Register  to view this content.

You can then rename and delete sheets, etc., and the drop down will be recalculated when reactivating the sheet. As it's triggered directly in the Select Type sheet and the activeworkbook, no need to clarify a variable for that sheet or to refer to it as thisworkbook.

Rgs,
berlan

EDIT: didn't see daffodil11's new post suggesting the very same approach before posting.