mardi 17 mars 2020

How to delete all checkboxes in a specific row in VBA

I have got one to three checkboxes in Columns D, F and G depending on certain criteria. Some rows get delete entirely others remain.After the deleting the whole row is shipt upwwards. The deleting function is given below. The problem is that the row with its values get deleted but the 3 checkboxes in that row do not. Is there a possiblity to get the chckboxes deleted as well when the entire ros gets deleted?

Worksheets("Table1".).Cells(k, "D").EntireRow.Delete shift:=xlUp



Aucun commentaire:

Enregistrer un commentaire