How to populate a ComboBox or a ListBox in a UserForm ?

All replies

• 

  

  1

  Sign in to vote

  Hi,

  Listbox1.AddItem "Content"

  ComboBox1. AddItem "Content"

  Greetings,

  Friday, November 16, 2012 3:15 PM
• 

  

  0

  Sign in to vote

  Thanks Jan,

  Is it possible to populate a list or a combo with an array?

  Thanks again

  Friday, November 16, 2012 5:29 PM
• 

  

  0

  Sign in to vote

  Hi,

  AFAIK not in one statement but you could do it in a loop.

  Greetings,

  Friday, November 16, 2012 7:18 PM
• 

  

  1

  Sign in to vote

  Try:

  Private Sub UserForm_Initialize()
  Dim Arr(0 To 4) As String
      Arr(0) = "One"
      Arr(1) = "Two"
      Arr(2) = "Three"
      Arr(3) = "Four"
      Arr(4) = "Five"
      Combo.List = Arr
  End Sub

  
  

  ---

  Rod Gill

  The one and only Project VBA Book

  Rod Gill Project Management

  • Proposed as answer by Parth Rawal Saturday, November 17, 2012 8:32 AM
  • Marked as answer by WLID1966 Saturday, November 17, 2012 5:28 PM

  Friday, November 16, 2012 7:43 PM