Sub SuKienNutLenh()
Dim ShpName As String
ShpName = Application.Caller
MsgBox ShpName
Dim shp As Shape
Set shp = ActiveSheet.Shapes(ShpName)
Dim dong As Integer
dong = shp.TopLeftCell.Row
MsgBox dong
End Sub
Sub Button32_Click()
'ActiveSheet.Buttons.Add Range("N4").Left, Range("N2").Top, Range("N2").Width, Range("N2").Height
For i = 1 To 10
ActiveSheet.Buttons.Delete
Next
For i = 1 To 10
'ActiveSheet.Buttons.Add(Cells(i, 1).Left, Cells(i, 1).Top, Cells(i, 1).Width, Cells(i, 1).Height).Select
ActiveSheet.Buttons.Add(0, 10, 10, 10).Select
With Selection
.Caption = "Chon"
End With
ActiveSheet.Buttons.OnAction = "SuKienNutLenh"
Next
End Sub
Tạo button vào dòng trong VBA Excel