ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   listbox with checkbox or radiobutton groups (https://www.excelbanter.com/excel-programming/291047-listbox-checkbox-radiobutton-groups.html)

Mark[_36_]

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



Mark[_36_]

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





onedaywhen

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



All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com