Excel 2010 ListBox selection type problem

Question

I have Excel 2010 installed on my laptop. In one whorksheet, I added one listbox(form control) and have several items in it, I set the 'selection type' to 'Extend', I do can select multiple items by pressing SHIFT and mouse, but I can not select multiple items while I press CTRL and mouse, when I did this, it's like when I Right clicking the listbox. My home computer also installed office 2010 but do not have this problem.

Anybody knows why this happening? Thanks a lot!

Answer 1

Hi,

If you really want to use CTRL, the ListBox for ActiveX Control can meet your needs.

How to add a ListBox (ActiveX Control)?

Click the Developer tab >> Insert >> ListBox (ActiveX Control)

If you can not see the Developer tab, please do the following steps first:

Right-click the ribbon >> Customize the Ribbon >> check Developer

How to add a column data to the added ListBox?

e.g, there are four data rows in column A:

──

 A

──

 5

 8

 6

 3

──

Press [Alt+F11] to open the VBE Environment, and then paste the following code to a Module (Insert >> Module)：

Sub AddRangeData2ListBox()

    Dim arrList

    arrList = Range("A1:A4")

    ListBox1.List = arrList

End Sub

{5, 8, 6, 3} will add to the ListBox after you run the macro above.

How to set the selection type of the added ListBox?

Go back to Sheet1, click the Developer tab >> Design Mode >> Properties >> select the added ListBox >> MultiSelect >> 2 - fmMultiSelectExtended >> Design Mode

Note:

In this way, every time you open the Excel document, the list is empty, to keep the original data, you should add the Workbook_Open event in ThisWorkbook like below:

Private Sub Workbook_Open()

    AddRangeData2ListBox

End Sub

Best regards,

Cristin

Answer 2

Hi Cristin,

Now I'm using the "Multi" type, it does work, but the thing is; I might have selected several items before I close the spreadsheet, when I reopen it, I might just want to select some items which are not the same as what I have selected, then I have to unselect those first and then select what I really want.

Anyway, if there is no way for using CTRL, I have to accept type 'Multi', thanks a lot.

Answer 3

Hi,

Please change the selection type of ListBox to "Multi".

Cheers,

Cristin

Answer 4

Hi ,

Thank you for your advice, but what if I just want to select item 1, 3 and 5? I don't want to select item 2 and 4.

Answer 5

Hi,

Select multiple items by pressing CTRL and mouse means that just select the listbox control.

I think of a way to work around this problem:

Select multiple items by dragging the mouse up or down instead of pressing CTRL.

Cheers,

Cristin