| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox vs Combobox
Thanks for your help!
Les "merjet" wrote: It's easier to populate a ComboBox when all the items are in one column, but in one row is doable. To disable allowing the user to add items, include the next-to-last line below, or set it in the Properties Window. Private Sub UserForm_Initialize() Dim c1 As Range Dim c2 As Range Dim iCol As Integer Set c1 = Sheets("Airports").Range("C1") Set c2 = c1.End(xlToRight) For iCol = 3 To c2.Column ComboBox1.AddItem c1.Offset(0, iCol - 3).Value Next iCol ComboBox1.Style = fmStyleDropDownList End Sub Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listbox vs Combobox | Excel Programming | |||
| comboBox vs Listbox | Excel Programming | |||
| Combobox v Listbox | New Users to Excel | |||
| Combobox/listbox | Excel Discussion (Misc queries) | |||
| Combobox or Listbox | Excel Programming | |||
Threaded Mode
