Populate Combo box

HI Experts
I have 2 dimesional array

  Public fee_str(3, 2) As String
I wuould like to display in a combobox and store the selected rows second column value to arx
please help
b001Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jcrozier21Connect With a Mentor Commented:
'populate
dim i as integer
i=0
do while i < 3
combo.AddItem fee_str(i,0) & ";" & fee_str(i,1)
i=i+1
loop

Open in new window


dim secondColumnValue as string
secondColumnValue = combo.column(1)

Open in new window

0
 
jkaiosIT DirectorCommented:
To display contents of array in combo box (assuming the combo box is named Combo1):

Dim ii as Integer, jj as Integer
For ii = 0 to 3
   For jj = 0 to 2
     Combo1.AddItem fee_str(ii,jj)
   Next
Next

Open in new window


To display selected item in combo box:

Private Sub Combo1_Click()
   Debug.Print "selected item: " & Combo1.Text
   Debug.Print "selected item: " & Combo1.List(combo1.ListIndex)  'same as above
End Sub

Open in new window

0
 
b001Author Commented:
i have error

Error      1      'AddItem' is not a member of 'System.Windows.Forms.ComboBox'
0
All Courses

From novice to tech pro — start learning today.