Copy data against each checked check box and paste in a new excel workbook

Hello everyone,
Newbie at VBA coding.

I am trying to write a code which will allow me to do 2 things:
1) Copy paste a blank form in a new workbook for every checked check box
2) In this newly created blank form i want to paste the "Name" field which will be picked up from the base sheet

Pl find attached excel sheet with the code I have managed till now. I have written code for one checkbox as I do not know how to write code for loop.
Sheet 1 - Base sheet with info about name
Sheet 2 - Blank format with name field blank

* I am continuously getting error Method paste of object failed.
Your help will be highly appreciated.

Hi rnd
Welcome to the forum.
I'd use the "linked Cell" value to work out which value to copy to new work book

then modify something like

Please Login or Register  to view this content.

Hi rnd

for each of the checkboxes set the propeties "Linked Cell"
Checkbox1 linked cell = D3
Checkbox2 linked cell = D4
Checkbox3 linked cell = D5.....etc

Please Login or Register  to view this content.

no problems rnd
thanks for posting