Userform Checkbox inside a Listbox and is in turn inside a Page

[MikeKhael]

Good day! I am fairly new to userforms (though I was able to follow some of the instructions here when I create macros and VBA), and I am curious if it is possible to create a userform with Pages and in each page there is a Listbox that has multiple Checkboxes (around 5 to 15), and has a textbox at the bottom whilst outside of the Pages section, but still within a userform? I tried to manually design or create it and it works, but I wonder how the codes would go as far as making each checkbox independent with one another, but every time a checkbox is checked it copies the value of that checkbox to the Textbox,and conversely if it is unchecked it removes the value of that checkbox from the textbox.

 

[My Aswer Is This]

You said:
Quote:
"List box that has multiple Checkboxes (around 5 to 15)

Do you mean 5 to 10 values in the list box.

A checkbox is only True or False

 

[MikeKhael]

You said:
Quote:
"List box that has multiple Checkboxes (around 5 to 15)

Do you mean 5 to 10 values in the list box.

A checkbox is only True or False

Hello, Yes, I mean a listbox or a combobox I dont know how it is called. And it can hold multiple checkboxes, like 5 to 10 checkboxes.

 

[My Aswer Is This]

You again said:
Quote:
"it can hold multiple checkboxes, like 5 to 10 checkboxes

A list Box cannot hold Checkboxes.

 

[NoSparks]

MAIT, have a look at this

Create a list box with option buttons or check boxes

Office VBA reference topic

learn.microsoft.com

 

[My Aswer Is This]

So now I have been told a Listbox can have check boxes.
I will continue to monitor this thread to see what I can learn.
I'm not able to help you but I'm sure someone else here may be able to help you.

 

[MikeKhael]

You again said:
Quote:
"it can hold multiple checkboxes, like 5 to 10 checkboxes

A list Box cannot hold Checkboxes.

If the ListStyle is Extended it will be able to show the list in the form of Checkboxes. I was able to read somewhere in this forum that checkboxes is possible in the listbox. Though my question is, will it be possible to hold more than 5 checkboxes?

 

[MikeKhael]

MAIT, have a look at this

Create a list box with option buttons or check boxes

Office VBA reference topic

learn.microsoft.com

Thank you for the link. It does help with what I am planning to do.