VBA Checkbox.

[alexub12]

Hello all. I need help with the following.

I want to be able to add a checkbox to a specific Column-Cell everytime a row is inserted the checkbox should be added to the same row just on the new row that was added.

so far I have found plenty of material out there helping me figure out how to add a checkbox I just can't figure out how to add it on the new row.

if the only solution is to add a button to add a row when click, that is an acceptable solution.

thanks for the help in advance

 

[DanteAmor]

Put the following code in the events of your sheet

Private Sub Worksheet_Change(ByVal Target As Range)
    celdas = Target.Count
    fila = Target.Row
    cuenta = WorksheetFunction.CountBlank(Rows(fila))
    If celdas = Columns.Count Then
        If cuenta = celdas Then
        
            ActiveSheet.CheckBoxes.Add(Left:=Range("D" & fila).Left, _
               Top:=Range("D" & fila).Top, Width:=Range("D" & fila).Width, _
               Height:=Range("D" & fila).Height).Select
               
            ActiveSheet.OLEObjects.Add "Forms.CheckBox.1", _
               Left:=Range("E" & fila).Left, Top:=Range("E" & fila).Top, _
               Width:=Range("E" & fila).Width, Height:=Range("E" & fila).Height


        End If
    End If
End Sub

When you insert a single row in column D of the new row a checkbox will be inserted and in column E an ActiveX checkbox will be inserted.

Try and tell me

 

[My Aswer Is This]

Just curious. Why do you need a checkbox added to each new row?
Will there be a script then used for the checkbox to do something?

You do know script can be run by just double clicking right clicking or many other ways without the need of a checkbox.