Excel Worksheet ListBox

[John Howard]

I have a worksheet multiselect ListBox that despite not being locked and
being enabled does not allow any selection to be made.

Any ideas on why this is?

 

[OssieMac]

Hello John,

Firstly there are 2 type of List Boxes. One from the Forms Toolbar and and
ActiveX one from the Control ToolBox toolbar. (In xl2007 they are named in
the selection dropdown panel). Which one are you using?

What do you mean by 'does not allow any selection to be made'? Are you
getting an error message indicating it is protected or are you just not able
to highlight your required selections?

If using a Forms toolbar ListBox and getting a protected message then ensure
that you don't have a linked cell that is locked. (Being multiselect the
linked cell will always display zero even though you are able to set it but
it will cause an error on selections.)

 

[John Howard]

Hi Ossie,
Thanks for responding.

My ListBox that I am using is ActiveX type in Excel 2003.

I am not getting any error message, the list though fully visible does not
allow any items to be selected.

Being a MultiSelect ListBox the LinkedCell property is left blank
The worksheet is not protected
The property Locked = False and Enabled = True

I have used ActiveX ListBoxes many times but have never encountered this
before.
It's driving me nuts :-:

 

[theinventor]

I know this is a very old post but in case anyone else comes across this issue I thought I would respond. I have had the same problem with a multi select activex list box appearing to lock / freeze. After a lot of investigation I have removed all screen updating in all the macros and it seems to be fixed.

application.screenupdating = false