Temporarily Change The Size of a ListBox

[ercedwards]

I have a data entry spreadsheet where users can make multiple selections in various cells.
In some cells I can use simple drop-down lists.
In other cells I need to allow the users to make multiple selections.

I know I can use ListBox with multiselect to do this but here is the challenge.

I want to put the Listbox in a cell (Column Width=14 Row Height=18)
Since Combox boxes don't allow multiselect here is what I'd like to do.
When the user goes to say cell C3 where my ListBox is, the ListBox would expand to a larger/useable size, the user clicks their choices
and then the ListBox returns to its usual size.

Is this possible with a macro by using something like a MouseOver?

Thanks

 

[Ken Cowen]

I think you would be better off with a button on the cell, sized to match the cell. Clicking the button should initialize a userform and the userform should have a multiselect listbox, with code to do what you want with the selections.
Ken