How do you create a Combo Box(ActiveX Control) where you can select multiple options in the list?

[CDickson]

Hi,

I am trying to create a drop down list that allows me to select multiple options within the list in Excel 2007. I know that you can do this with a Combo Box (Form Control) but the option to select 'Move and size with cells' (Format Control > Properties > Object Positioning) is grayed out and I need the list to move with the cell it is in.

With a Combo Box (ActiveX Control) you can select 'Move and size with cells' but I can't figure out how to get it so that I can select multiple options within the list. I thought that under 'Properties' for the ActiveX Control that I could select 'Check Boxes' under 'ListStyle' but I am only given the options of 'Plain' and 'Option Buttons'. Is there a reason I don't have the 'Check Boxes' option? Am I missing a step or am I on the wrong path?

Thanks a million for any insight you may have!

 

[SamTYler]

Xl 2003 = Multiselect property = True

I'm sorry that I don't have time to help you, but this post will bump your query back to the top so someone who can might see it.