As the title says im struggling to get this to function properly. all I can manage to do its put all items into 1 single column of a list box, spaced out.
Private Sub CommandButton9_Click()
Dim i As Long
Dim Duplicate As Boolean
If Me.genbuildhistorylist.Text <> "" Then
For i = 1 To Me.genemaillist.ListCount
If Me.genemaillist.List(i - 1) = Me.genbuildhistorylist.Column(0, _
Me.genbuildhistorylist.ListIndex) & vbTab & _
Me.genbuildhistorylist.Column(1, Me.genbuildhistorylist.ListIndex) Then
'Duplicate Entry
Duplicate = True
Exit For
End If
Next i
If Duplicate = False Then
Me.genemaillist.AddItem Me.genbuildhistorylist.Column(0, _
Me.genbuildhistorylist.ListIndex) & vbTab & _
Me.genbuildhistorylist.Column(1, Me.genbuildhistorylist.ListIndex)
End If
End If
End Sub
how would i go about altering this to rather than tabbing, to select the next column of the list box?
Bookmarks