VBA code for adding and deleting check boxes on value

[Arthras77]

Hi

I don't really know how to code the VBA to insert the checkbox on value.

By selecting text from the list appropriate check boxes will be inserted or deleted to create a specific set. It would be perfect if it would work on the whole sheet.

I would really appreciate your help

 

[My Aswer Is This]

Hi

I don't really know how to code the VBA to insert the checkbox on value.

By selecting text from the list appropriate check boxes will be inserted or deleted to create a specific set. It would be perfect if it would work on the whole sheet.

I would really appreciate your help

My personal opinion is that having a lot of checkboxes on your sheet is not a good ideal.

1. What do you expect to happen when you click on the checkbox?
2. It would be much easier to use a double click script.
Double click the cell and something will happen.
If this would work for you give me the ranges where you want to double, click and what do you want to happen when you double click the cell. And this would be a Vba solution.