I want a Listbox to be launched when I click the Option button. I am using the below code for that.
I have placed the Listbox in a different userform (I hope this is an elegant method). This Userform contains only the Listbox, so the below code for launching the form/Listbox.
However, the option button shouldn't get marked unless all the values in listbox are marked as "Yes". The moment all the values are checkmarked, the listbox/userform unloads and the Option button gets selected.
How do I check if all the items are selected in a Listbox?
Please advise the code for the same.
I have placed the Listbox in a different userform (I hope this is an elegant method). This Userform contains only the Listbox, so the below code for launching the form/Listbox.
VBA Code:
Private Sub Optionbutton1_Click()
HintForm.Show
End Sub
However, the option button shouldn't get marked unless all the values in listbox are marked as "Yes". The moment all the values are checkmarked, the listbox/userform unloads and the Option button gets selected.
How do I check if all the items are selected in a Listbox?
Please advise the code for the same.