Listbox selection base on opened workbooks

[yinkajewole]

there is a listbox that contain file names, how do i programmatically select the name of an active opened file in the listbox as soon as the userform initialize?

 

[My Aswer Is This]

Show me the code that loads the Workbook names into the Userform Listbox
And tell me the name of the UserForm ListBox

And what do you want to happen when the script selects the active Workbook name in the ListBox?

 

[yinkajewole]

Private Sub UserForm_Initialize()
Dim wkb As Workbook
With Me.ListBox1
    For Each wkb In Application.Workbooks
        .AddItem wkb.FullName
       Next wkb
End With
End Sub

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.