mardi 3 mai 2016

dropdownmenu automatically checks checkbox

I have a question, i've tried to search the internet alot, but havent found a solution to help me.

Heres my problem: I have a dropdown menu in sheet3 (called ws_step3 in vba) at cell J3. The dropdown menu has 9 options, where 2 of those options automatically should enable a checkbox (lets call the checkbox "Coffeecup")

The 9 options are A,B,C etc.

Im looking for a VBA code that automatically checks that checkbox if 2 of the options are checked (lets say its C and F that checks the checkbox)

Im using Active X checkboxes.

Hope anyone can help me.

TY in advance from a newcomer in VBA :-) /Klaus




Aucun commentaire:

Enregistrer un commentaire