Help needed for ActiveX checkbox VBA

**thecatlady** · 10-31-2020, 01:27 PM

Hi, I have a pretty complex project for work that has 3 columns of checkboxes that are either enabled, disabled, or auto-selected based on the user selection in another cell. There is also a "select all" check box at the top of each column. I've got the basic code and it was working, but it is not working down each column. It seems to be working weirdly based on the numbering of the checkboxes. I need to have this finished before Monday, and I can't figure it out. Can anyone help? I didn't see it specifically listed in the rules, but I can offer payment for the help - I don't have a lot, but will pay what I can as I am desperate! If you think you can help I can send the worksheet, it is too large to attach here.

**Roel Jongman** · 10-31-2020, 03:33 PM

You do not give us much to go on..

please find attached a small stripped sample of how checkboxes can be made to interact

in the sample you will see if you check the show all tabs checkbox (checkbox4) it will toggle the state for checkbox 1 thru 3 to eighter false (unchecked) or true (checked)
Which then triggers certain tabs to appear or disappear.

Getting a logical naming of checkboxes with a sequential numbering can help limit the amount of code but requires a very good planning of exact needs to make it function wel under all circumstanses if you are unders time pressure it might be best to have long code with a setting for each checkbox to mirror or counter

This code belsow will set all 3 checkboxes to the state of checkbox 4

Please Login or Register  to view this content.

if you ad a "Not" before Checkbox4 f.e.

Please Login or Register  to view this content.

then checkbox1 will be set to the opposite of checkbox4

I hope this helps you get to where you need to be..
if not please explain a bit more and read the yellow box above the forumlist on how to attach a sample file so it is a lot easier for us to help you..