Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent: How to use CheckBoxes in ListBox
Hello,
I am going crazy because I try to access the Value of a checkbox. Here is what I do: * Create a ListBox control * Set ListBox.ListStyle to fmListStyleOption * Set ListBox.MultiSelect to fmMultiSelectMulti This results in a control with checkboxes in front of all list elements. The checkboxes can be checked/unchecked with the mouse. However, I cannot out the code needed to * read the state of the checkbox * set the state of the checkbox in code I have been reading the VBA Help for hours now but could not figure out how to do this. I am begging for your help. Cheers, Oliver |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent: How to use CheckBoxes in ListBox
Oliver,
This should get you started With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) = True Then MsgBox .List(i) & " is selected" End If Next i End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mr. T" wrote in message s.com... Hello, I am going crazy because I try to access the Value of a checkbox. Here is what I do: * Create a ListBox control * Set ListBox.ListStyle to fmListStyleOption * Set ListBox.MultiSelect to fmMultiSelectMulti This results in a control with checkboxes in front of all list elements. The checkboxes can be checked/unchecked with the mouse. However, I cannot out the code needed to * read the state of the checkbox * set the state of the checkbox in code I have been reading the VBA Help for hours now but could not figure out how to do this. I am begging for your help. Cheers, Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Enabling checkboxes in a listbox control | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |