Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Add names of all open workbooks to a combo box list

Here cboCsvFileName is the name of the combo box

Dim wb As Workbook

For Each wb In Application.Workbooks
    With cboCsvFileName
        .AddItem wb.Name
    End With
Next wb

Contact Form

Name

Email *

Message *

Popular Posts