Excel Worksheet ListBox
 

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?
--
Regards
John Howard
Sydney, Australia

Excel Worksheet ListBox
 

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.)

--
Regards,

OssieMac


"John Howard" wrote:

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?
--
Regards
John Howard
Sydney, Australia

Excel Worksheet ListBox
 

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 :-:
--
Regards
John Howard
Sydney, Australia


"OssieMac" wrote:

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.)

--
Regards,

OssieMac


"John Howard" wrote:

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?
--
Regards
John Howard
Sydney, Australia