Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating combobox/listbox
This topic has certainly been answered before, but I'm not able to find an
answer. How do you populate list/comoboxes via VBA in Excel. I want to populate the box with all the elements in a range. Is there web-site that gives good information about userforms and listboxes in excel? Torstein S. Johnsen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating combobox/listbox
Here's an example:
Private Sub CommandButton1_Click() Dim rng As Range For Each rng In Range("A1:A20") ComboBox1.AddItem rng.Value Next End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "Torstein S. Johnsen" wrote in message ... This topic has certainly been answered before, but I'm not able to find an answer. How do you populate list/comoboxes via VBA in Excel. I want to populate the box with all the elements in a range. Is there web-site that gives good information about userforms and listboxes in excel? Torstein S. Johnsen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating listbox | Excel Discussion (Misc queries) | |||
Populating TextBox Value--using ListBox | Excel Programming | |||
populating a multi-column Listbox | Excel Programming | |||
Populating a userform 3 col listbox | Excel Programming | |||
Populating multicolumn listbox the wrong way | Excel Programming |