VBA在列錶框ListBox指定行插入數(shù)據(jù)項(xiàng)目

VBA在列錶框ListBox指定行插入數(shù)據(jù)項(xiàng)目

Listbox的additm 第2箇蔘數(shù) 可指定插入的位置

Option Explicit
Dim A As String
Dim B As Integer
Dim C As Integer
Dim I As Integer

Private Sub CMDADD_Click()
B = InputBox("想添加到第幾行?")
C = List1.ListCount
If B < 0 Or B > C + 1 Then
InputBox ("請不要超過現(xiàn)有行數(shù),請重新輸入")
Else
If Text1.Text = "" Then
MsgBox ("請?jiān)谖谋究蛑休斎雰?nèi)容")
Else
For I = C To B Step -1
List1.List(I) = List1.List(I - 1)
Next I
List1.AddItem Text1.Text, (B - 1)
End If
End If

End Sub