lundi 10 avril 2023

VBA : Autofiltering with checkbox userform

I would to filter some elements from a column and I am using userform. I used the checkboxes to select values (to be filtered) and used 'if' condition to check for status(true and false). A command box as okey button. But it is filtering only first value. Pls help me with. Sharing the code herewith. I just want the column 2 to be filtered. Possible outcomes are A1 or A2 or A3 or B1 or B2 or B3 or E or L1. I would be happy if I can convert the if output to arrays.

enter image description here




Aucun commentaire:

Enregistrer un commentaire