code populates list boxes in active sheet, but does not populate boxes in subsequent sheet

Hi, all,

I have code that populates 3 combo boxes when the workbook is open. This works fine for the sheet that is active, but it is not populating the comboboxes in any other tab (I have identical tabs that I want to be able to navigate between).


I believe this has something to do with the Private Sub workbook_open() option, but I don't know what I should change it to to make this work.

Please Login or Register  to view this content.

Thanks, Norie,

The worksheets in this workbook are all identical, and so what I would like is to alter the above code so that it runs when the workbook is open, and also when another sheet is selected. This way, the comboboxes in each sheet are updated once that sheet is activated.

Norie, you are wise. This accomplishes the task. Thanks for the help!