how to create a dropdown list with number of checkboxes

[OAhmed]

Hi,


I have prepared a graph with checkboxes. Came very nice. Arranging all the checkboxes under the graph is not looking neat and tidy. I have too many checkboxes which I want to place them in a dropdown list. Is this possible.


Thanks.

 

[SirJB7]

Hi, OAhmed!

Even I've never tried to do such a thing, as far as I know it's not possible. Unless someone proves me wrong.

Regards!

 

[keymaster]

You can use Active X controls for this. I think there are a few that does this job. But you will have to use some macros to deal with check / uncheck events.

 

[NARAYANK991]

Hi Ahmed ,


You can use a ListBox with a change in the ListStyle property to fmListStyleOption ; this will display a checkbox against each item in the ListBox.


The more important point is that checkboxes should be visible on the chart for two reasons , so that the viewer knows :


1. what options have been selected

2. what are all the options available


If you use a drop-down list , neither of the above will be possible , assuming that multiple selections are possible.


If arranging the checkboxes horizontally , at the bottom of the chart , is not neat , arrange them vertically , to the right of the chart , so that the checkbox text is to the right , and more checkboxes can be accommodated in the available space.


Narayan