View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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