Dim'ing Userform ComboBoxes

  • Hi,


    I've got a UserForm with various numbers of Checkboxes (in groups of 4) and I want to dim them out so that I can cycle through and make actions on each group depending on whether the first in the group is locked or not.


    The prblem I have is that when I try to dim the controls the code seems to keep referring to the value of the control instead of the control itself.


    What am i doing wrong? An example is below...


  • Re: Dim'ing Userform ComboBoxes


    Untested..but you can try



    You could also loop through the controls of the form and if it is a combobox then set the array at that time instead of having to hard code each Set line.