Userform_initialize error Help

[fokeiro]

How you guys doing , i been following this site for a while and always been able to find help here, you guys awesome !!!!

Here is my issue i have a userform which shows all open workbooks, everything works fine i choose whatever workbook i want to work at , press ok and make it active, now i have this 2 codes on it

i have this so my PERSONAL.xlsb dont show

Dim wbk As Workbook
For Each wbk In Workbooks
If wbk.Windows(1).Visible = True Then
Me.ComboBox1.AddItem wbk.Name
End If
Next

also i have this one so the workbook where the form is doesn't show

Dim wb1 As Workbook
    For Each wb In Workbooks
        If wb.Name <> ThisWorkbook.Name Then ComboBox1.AddItem wb.Name
    Next wb
    ComboBox1.ListInde

now on this

Private Sub UserForm_Initialize()
    Dim wb As Workbook
    For Each wb In Workbooks
        If wb.Name <> ThisWorkbook.Name Then ComboBox1.AddItem wb.Name
    Next wb
    ComboBox1.ListIndex = 0

it works fine , if i replace everything with second code works fine but i cant manage to get them both together in

userform_initalize

so they both start.

can anyone share any light on how to merge them ?