Forms VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Forms
  4. Add names of all open workbooks to the list box
Sub UserForm_Initialize()
    Dim wkBook As Workbook
    For Each wkBook In Workbooks
        lstWorkbooks.AddItem wkBook.Name
    Next
End Sub