ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListBox Displaying With Some Items Already Selected In 2007 (https://www.excelbanter.com/excel-programming/410691-listbox-displaying-some-items-already-selected-2007-a.html)

IanC

ListBox Displaying With Some Items Already Selected In 2007
 
I have an application that I have been using without problems since Office
2000. It has a list box, which is populated using the command:

cyo_dialog.sel_box.RowSource = "product_list"

It then goes on to ensure that all the items are deselected with the code:

For a = 0 To (cyo_dialog.sel_box.ListCount - 1)
cyo_dialog.sel_box.Selected(a) = False
Next a
cyo_dialog.sel_box.ListIndex = 0

Since I started using this on 2007, for some unknown reason two of the first
three items come up selected (normally item 1 with either 2 or 3) , and are
then not deselected by the code that follows.

I have found 2007 to be very buggy and inconsistent in its running, but I
can see no reason why this should now be happening.

Thanks in advance.



All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com