Userform Checkboxes - Select All/Unselect

[jroo]

Hi - I'm creating a userform where I'd like to have about 10 checkboxes. How would I go about creating another check box that would select/unselect those 10 boxes?

I tried googling it and came across this piece of code below, but it only selects all. It doesn't allow me to unselect all. Please help. Thanks


Private Sub SelectAllCheckBox_Click()

Dim oCtrl As Control
For Each oCtrl In Me.Controls


If TypeOf oCtrl Is msforms.CheckBox Then
oCtrl.Value = True
End If
Next

End Sub

 

[My Aswer Is This]

I will see. Check back in a hour or two.

I guess whatever way will work. I can think of two intuitive ways to accomplish this:

1. Click and drag approach - A user would click and drag Competitors to rearrange them in the visible listbox.
2. "Move up" and "Move down" command - This could be two buttons next to the listbox that allow a user to click and select a option in the listbox, then click the "Move up" command button to push the selected competitor up in the list, or click the "Move down" command button to push the selected competitor down in the list.

Do you think this can be added somehow?

 

[My Aswer Is This]

I really do not know how you could do this.
We could have another listbox and you could copy the items to it.

Like right click on Listbox1 value and that value could be added the ListBox3

 

[gaudrco]

I'm not really sure if that would work. I will bring this topic to a new post to see what others think. Thank you very much for your help

 

[gaudrco]

We could have another listbox and you could copy the items to it.

There was another idea to create groups of Competitor. Is there a way to create groups of line items from the listbox?

For example: I place a button called "Create Group" on the current userform. The "Create Group" button opens a new userform. The "Create Group" userform looks very similar to the first userform; 2 listboxes. The first listbox will have all the competitor names. When the user double clicks a Competitor name, the competitor goes into the second listbox which becomes the group. The user can add as many competitor to the second listbox for grouping. When they are finished, they enter the name of the grouping in a field box and click a button called "Finish". When they click "Finish", the newly created group name will appear in the first userform. When a user double clicks the group name, all of the competitors associated with the group move to the opposite listbox which will allow the users to hide and show columns for groups of competitors in one action.

Can this be coded?

 

[Fluff]

As you have now started a new thread for your new problem, you should stick to that thread. This thread is now closed.