你都会点击更新List了,这个应该不在话下啊。 Private Sub ListBox1_Click() With UserForm2 r = Me.ListBox1.ListIndex + 2 i = .ListBox1.ListCount .ListBox1.AddItem .TextBox7.Text .ListBox1.List(i, 1) = .TextBox1.Text .ListBox1.List(i, 2) = Sheets("引用").Cells(r, 2) .ListBox1.List(i, 3) = Sheets("引用").Cells(r, 3) .ListBox1.List(i, 4) = Sheets("引用").Cells(r, 4) .TextBox8 = Val(.TextBox8) + Sheets("引用").Cells(r, 4) End With End Sub |