Tạo button vào dòng trong VBA Excel

Tạo button vào dòng trong VBA Excel

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

Bài viết liên quan:

Tạo button vào dòng trong VBA Excel