Adding change event to dynamically created option buttons on userform

Good morning forum

I have a userform that is populated dynamically based on variable data downloaded from a database. I want to add a change event to the option buttons, to modify the total quantity. The total quantity would increase by the quantity listed every time that "Shipped" was selected, or be reduced when "Not shipped" is clicked. Any suggestions on how to get the change event for the option buttons into this dynamic form? I'm attaching a spreadsheet, with some macro lines disabled to prevent errors in testing, and stop database access.

Thanks for reading

Why not use a listbox?

It can be populated dynamically and can be set to display option/check buttons for each item.

Norie, I can look at that, but will that help my problem of updating the total quantity based on actions for a given line? Sorry if it is a dumb question, learning lots, but in some areas I definitely need work...

Have a look at the attached file.

Norie, I haven't really used a listbox before, great suggestion I'll modify a bit as there will never be a shipped "true" condition being listed, that field is left over from earlier revs, but only "FALSE" items get downloaded into the sheet.
Anyhow, thanks for the quick response, seems I overcomplicated my original approach.
You rock!