Unable to Select ListBox Items

[esvenk]

Hi everyone,
I have a worksheet with a few "Multi-Select" type listboxes in it. I cannot seem to select the items within those listboxes... the mouse icon doesn't even change, it just shows that little plus-sign that is the default when you're just in your worksheet. (they're also ActiveX listboxes)

I can select them if I go into my Developer tab and select and deselect the "Design Mode" button. then everything works fine (mostly). Or if I resize the subwindow for the workbook. Then it (again, mostly) works fine.

It's like I have to trick Excel into allowing me to click on the checkboxes in my ListBox.

Some people I've given the file to use Excel 2007 and the file works for them. (I have Excel 2010)

I've looked up info on bound/unbound forms, but I can't tell if it applies, or how to use that.
They were not created with a VBA macro, they were made using the buttons in the developer tab.

One final thing (if it helps):Below the listboxes, I have some shapes that, when pressed, will take the selected items from their respective checkboxes and put them into some cells.

Here is the file:
Setup form_Blank.xlsm

Thank you all so much!!

[6StringJazzer]

I can select them if I go into my Developer tab and select and deselect the "Design Mode" button.

That's your problem, right there. You can't use controls embedded in a worksheet if Design Mode is on. It's so you can manipulate the controls for design purposes without activating them.

[Izandol]

I think ActiveX and freeze panes does not work so well. You may use Forms controls instead - I have put in attachment.

[esvenk]

That's your problem, right there. You can't use controls embedded in a worksheet if Design Mode is on. It's so you can manipulate the controls for design purposes without activating them.

But I have design mode off and it still doesn't work when I first open the file. I open it, see that it doesn't work, and then toggle the design mode first to on and then off again before they'll work.

[esvenk]

Izandol---This works great!!! Thank you so much!!
Although I don't think it was the freeze panes that did it, the ActiveX controls were messing up even before I put those on. Weird.
Oh well, the good ol' Forms Controls works great! In fact all I needed to do with your file was to make them 'Multi', instead of 'Extended' (just in case anyone with the same problem comes across this post).

Thank you so much!

[Izandol]

You are welcome.

For me, removing freeze panes had same effect as switching Design mode button.