ActiveX List Box Drop Down Box Count

Hello all,

I just started digging into ActiveX recently, and I'm trying to make a list box which you can select multiple data from, and when they are all selected, the drop down would select the count of the items selected.

For example, the array from which the drop down box is selecting from has items Chocolate, Vanilla, and Whipped Cream. A user can go in and select any combination from those 3. Say they select Chocolate and Vanilla from the list. After selecting them and clicking off per say, the drop down box will select a value of 2, which can be then used for calculations that are used in the spreadsheet.

Any background on how to do this will be greatly helpful. I've tried to do research on this topic but I'm coming up with a blank. All your help is greatly appreciated!

Hello farzyness,

Are you using two controls a ListBox and a Drop Down? I have never seen a Drop Down ListBox that was capable of multiple selection. Which toolbar is this control located on?