| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox items
"Soniya" wrote in message ... Hi All, How can I have AB,AC,AD as combo box items without usig row source? TIA Soniya By explicitly adding them to the combobox from VBA On a sheet With ActiveSheet.OLEObjects("ComboBox1").Object .AddItem "ab" .AddItem "ac" .AddItem "ad" End With on a userform With ComboBox1.Object .AddItem "ab" .AddItem "bc" .AddItem "cd" End With Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Access items stored in combobox | Excel Discussion (Misc queries) | |||
| formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Threaded Mode
