Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Active X Controls
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Active X controls | Excel Discussion (Misc queries) | |||
Active-X Controls - Transfer to Mac (excel) | Excel Discussion (Misc queries) | |||
Active X Controls | New Users to Excel | |||
How do I stop active x controls from moving after a print preview | Excel Discussion (Misc queries) | |||
Active X controls | Excel Discussion (Misc queries) |