vba返回选中单元格的行列值:
代码如下:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "你选中了:" & Target.Row & "行," & Target.Column & "列"
MsgBox Target.Address 'ADDRESS绝对地址
End Sub
运行结果如下:
vba返回选中单元格的行列值:
代码如下:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "你选中了:" & Target.Row & "行," & Target.Column & "列"
MsgBox Target.Address 'ADDRESS绝对地址
End Sub
运行结果如下:
本文标题:vba返回选中单元格的行列值
本文链接:https://www.haomeiwen.com/subject/nwrcjqtx.html
网友评论