View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Populating Active X Controls

Steven,

If you put your list on a worksheet and name the range, just put this name
as the ListFillRange (if the combobox is on a worksheet), or put it as the
RowSource (if the combobox is on a form).

Or use this code (note that I used the activate event, you can use any event
or put it into a standard sub):

Private Sub UserForm_Activate()

With ComboBox1
.AddItem "apples"
.AddItem "oranges"
.AddItem "pears"
End With

End Sub

steve

"Steven Stadelhofer" wrote in message
...
Can you tell me how to populate an Active X Control -
e.g., a combo box with a small list e.g., three items,
like apples, oranges, and pears. I am not familiar with
Visual basic - can this be done somewhere in the
properties window?

Thank you,
Steve