Private Sub UserForm_Initialize() Dim wkb As Workbook For Each wkb In Workbooks cboWkb.AddItem wkb.Name Next wkb cboWkb.ListIndex = 0 End Sub
Private Sub cmdClose_Click() Workbooks(cboWkb.Value).Close End Sub