Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox with checkbox or radiobutton groups
Hi NG
How do one make a listbox that contains checkboxes or radiobuttons in multible groups. Thanks in advance Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox with checkbox or radiobutton groups
I found the answer and now its time to share with you guyz out there
Create a list box with option buttons or check boxes In the Properties window, select the ListStyle property. Click the drop-down arrow to display a list of available styles. From the list, choose Option. When the ListStyle property is set to Option, the MultiSelect property determines whether check boxes or option buttons appear in the list. When MultiSelect is Single, option buttons appear in the list. When MultiSelect is Multi or Extended, check boxes appear in the list. Regards Mark "Mark" wrote in message ... Hi NG How do one make a listbox that contains checkboxes or radiobuttons in multible groups. Thanks in advance Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox with checkbox or radiobutton groups
Set the listbox's ListStyle property to 1 (fmistStyleOption). Then, if
you set its MultiSelect property to 1 (fmMultiSelectMulti) you get checkboxes, 0 (fmMultiSelectSingle) and you get optionbuttons (radiobuttons). I dunno about the 'multiple groups' aspect. Maybe you need to use one listbox per group. -- "Mark" wrote in message ... Hi NG How do one make a listbox that contains checkboxes or radiobuttons in multible groups. Thanks in advance Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Listbox w/CheckBox Options | Excel Programming |