Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
POPULATE combobox
I am new with combobox stuff. I have created one but how do you populate
with an array$ using vba. where do you write code? A small example would be appreciated. Can't find a simple via google. Thank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
POPULATE combobox
Private Sub CommandButton1_Click()
arrTemp = Array(1, 2, 3, 4, 5) For intTemp = 0 To UBound(arrTemp) UserForm1.ComboBox1.AddItem arrTemp(intTemp) Next End Sub If this post helps click Yes --------------- Jacob Skaria "sunilpatel" wrote: I am new with combobox stuff. I have created one but how do you populate with an array$ using vba. where do you write code? A small example would be appreciated. Can't find a simple via google. Thank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
POPULATE combobox
If you already have an array and you're creating a userform, you can use that
userform's initialize procedure. Option Explicit Private Sub UserForm_Initialize() dim myArr as variant myArr = array("a","b","c") 'or however you determined the array me.combobox1.list = myArr End Sub sunilpatel wrote: I am new with combobox stuff. I have created one but how do you populate with an array$ using vba. where do you write code? A small example would be appreciated. Can't find a simple via google. Thank -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate combobox with sql from DAO | Excel Programming | |||
Populate a ComboBox | Excel Programming | |||
use selected value from one combobox to populate another combobox | Excel Programming | |||
Populate combobox | Excel Programming | |||
Populate a combobox | Excel Programming |