When my workbook opens to my first worksheet I'm trying to populate a combo box. This only seems to work when I move to one worksheet and the return to the worksheet with the combo box. Would like to be able to populate the combo box when the workbook opens.
Private Sub Worksheet_Activate()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets