跟你们说,你们倒以为很厉害似的,试下面的代码就明白! Private Sub DataGrid1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim i As Integer
On Error GoTo handler DataGrid1.SetFocus
If DataGrid1.Row = -1 Then MsgBox "最后一行" Else MsgBox DataGrid1.VisibleRows MsgBox DataGrid1.Row End If ' For i = 0 To 2 ' MsgBox DataGrid1.Columns.Item(i) ' RowArray(i) = DataGrid1.Columns.Item(i) ' Next i Exit Sub handler:
'最后掉了一句,去掉多余的语句如下 Private Sub DataGrid1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) On Error GoTo handler
If DataGrid1.Row = -1 Then MsgBox "最后一行" Else MsgBox DataGrid1.Row End If Exit Sub handler: Exit SubEnd Sub
dbgrid.Row = -1
Private Sub DataGrid1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim i As Integer
On Error GoTo handler
DataGrid1.SetFocus
If DataGrid1.Row = -1 Then
MsgBox "最后一行"
Else
MsgBox DataGrid1.VisibleRows
MsgBox DataGrid1.Row
End If ' For i = 0 To 2
' MsgBox DataGrid1.Columns.Item(i) ' RowArray(i) = DataGrid1.Columns.Item(i)
' Next i
Exit Sub
handler:
Private Sub DataGrid1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
On Error GoTo handler
If DataGrid1.Row = -1 Then
MsgBox "最后一行"
Else
MsgBox DataGrid1.Row
End If Exit Sub
handler:
Exit SubEnd Sub