Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add itemfrom a worksheet to a Listbox | Excel Programming | |||
Worksheet and Listbox | Excel Programming | |||
Help! Activate worksheet from a listbox | Excel Worksheet Functions | |||
Using a VBA listbox to populate a worksheet | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |