mattmac24
02-23-2004, 11:37 PM
ok at the moment my button looks like this:
Sub Command4_Click()
Dim line10
line10 = Combo1.ListIndex = -10
Dim line9
line9 = Combo1.ListIndex = -9
Dim line8
line8 = Combo1.ListIndex = -8
Dim line7
line7 = Combo1.ListIndex = -7
Dim line6
line6 = Combo1.ListIndex = -6
Dim line5
line5 = Combo1.ListIndex = -5
Dim line4
line4 = Combo1.ListIndex = -4
Dim line3
line3 = Combo1.ListIndex = -3
Dim line2
line2 = Combo1.ListIndex = -2
Dim Line1
Line1 = Combo1.ListIndex = -1
If line10 < 2 Then
Combo1.RemoveItem (Combo1.MultiSelect = 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line9 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line8 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line7 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
End If
If line6 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line5 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line4 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line3 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line2 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If Line1 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
it is really long and it dont even work...and the Dim things are wrong..im sure of it
and the start bit is ment to be there so just ignore that...
andone who knows how to delete all the items in 1 line please post....or tell me whats wrong with my bad one
thanks
matt
Sub Command4_Click()
Dim line10
line10 = Combo1.ListIndex = -10
Dim line9
line9 = Combo1.ListIndex = -9
Dim line8
line8 = Combo1.ListIndex = -8
Dim line7
line7 = Combo1.ListIndex = -7
Dim line6
line6 = Combo1.ListIndex = -6
Dim line5
line5 = Combo1.ListIndex = -5
Dim line4
line4 = Combo1.ListIndex = -4
Dim line3
line3 = Combo1.ListIndex = -3
Dim line2
line2 = Combo1.ListIndex = -2
Dim Line1
Line1 = Combo1.ListIndex = -1
If line10 < 2 Then
Combo1.RemoveItem (Combo1.MultiSelect = 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line9 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line8 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line7 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
End If
If line6 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line5 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line4 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line3 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If line2 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
If Line1 < 2 Then
Combo1.RemoveItem (Combo1.ListCount - 1)
GoTo Start:
End If
it is really long and it dont even work...and the Dim things are wrong..im sure of it
and the start bit is ment to be there so just ignore that...
andone who knows how to delete all the items in 1 line please post....or tell me whats wrong with my bad one
thanks
matt