How to add Checkedlistbox Control to VBA?

Question

I want to use Checkedlistbox Contorl in VBA. But I'm not able to find it.

I think I have to add its reference to references or add it in Additional Controls...............its not there!?

Any idea?

Answer 1

The closest equivalent in VBA is a multi-select listbox, which is a listbox with selectors (radio buttons) next to each entry. You can click the radio buttons to select a row.



HTH

Answer 2

I think the problem is that VBA is Visual Basic for Applications, such as Excel, Access, and Word.



Its functionality is not exactly the same as free standing Visual Basic.



I don't think you will find 'Checkedlistbox Control' is integral to VBA.

Answer 3

It is only in VB and not in Excel.

If you know the name of the control then right-Click the Control toolbox > Additional Controls and see if it is listed.



I've had a look but couldn't find anything but maybe your version might have it.