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!
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!