Private Sub UserForm_Initialize() Dim wks As Worksheet For Each wks In Worksheets cboWks.AddItem wks.Name Next wks End Sub
Private Sub cboWks_Change() Worksheets(cboWks.Value).Select Unload Me End Sub