Thread: Using combo box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AndrewArmstrong AndrewArmstrong is offline
external usenet poster
  
Posts: 24
Default Using combo box
Use something like this:

Private Sub UserForm_Activate()

'Clear Combobox
ComboBox2.Clear

'Add data from sheet
ComboBox2.AddItem Range("d11")
ComboBox2.AddItem Range("d12")
ComboBox2.AddItem Range("d13")

End Sub

Reply With QuoteReply With Quote