UserForm - Populate ComBoBox

    Hello,


    You need to populate your ComboBox as shown below, since you have modified ColumnCount = 2

    Code
    Private Sub UserForm_Initialize()
  ComboBox1.List = Sheets("Sheet1").Range("A2:B7").Value
End Sub

    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Carim

    Changed the title of the thread from “Application.WorksheetFunction.Match” to “UserForm - Populate ComBoBox”.

    Rick54


    FYI just marked your thread as solved

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login