Modify properties of multiple comboboxes

  • I have 10 Comboboxes on the same Worksheet. I named the first 5 of them "P1A1" to "P1A5", whereas the latter 5 were named "P2A1" to "P2A5".


    If I want to hide all 10 comboboxes at once using a command button, here's the current code I am using:



    I wonder if they are ways to simplify the codes above (using loops for instance) since I plan to add more comboboxes with similar naming conventions.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!