How to automatically generate invoices for selected rows?

I have written a code which automatically generates invoices if you click the command button "generate invoices" in "TripSummary" worksheet using the template in "Basic" worksheet.

But I want a code where invoices of only selected rows (by introducing checkboxes/ other method) gets generated and not all the rows.

https://drive.google.com/open?id=1kh...l7jeuGOIhpxZ75

Title is now much more descriptive Thank you

Create checkbox for each row, connect them to particular row (ex. checkbox in cell A1, connected with value to cell A1), then in Your macro Private Sub CommandButton1_Click() loop though whole column A and run main action from this macro only for Ax=1 (replace For myRow = 2 To lr for:

Formula:

Please Login or Register  to view this content.

Instead of creating checkboxes for each row, You can also do it by manual entry ex. X in col A and then in macro instead of checking = 1, You can to = "X"
Idea mainly the same, but creating 50 checkboxes, set them for cells......As You wish.

Try changing this

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

will create the checkboxes with a link to the row

Please Login or Register  to view this content.