deleting a row with checkbox and command button

Visual Basic Excel

For example if I would have a sheet with 1000 rows and checkboxes in the first column all named checkbox1, checkbox2, checkbox3 etc etc and a command button at the very bottom and what ever checkbox is checked and the command button is clicked those rows would be deleted.

I tried to solve that problem yesterday and it took me around 7-8 hours with always new problems as Im still a beginner.

Any useful help would be greatly appreciated

for i=1 to 1000

ActiveSheet.CheckBoxes(1).Value
next

previous message was sent accidently

for i=1 to 1000
if ActiveSheet.CheckBoxes(1).Value=1 then
//your code
end if
next



//if ActiveSheet.CheckBoxes(1).Value=1, that means that checkbox is checked