List box weirdness


Posted by Duane Kennerson on December 04, 2000 5:37 PM

I have two list boxes on one of my user forms. The two list boxes are used together
to create criteria for an autofilter sort that I do. There are 7 items listed in on list
box and three in the other. The code behind the scenes works perfect for 6 out of the seven
items in the first list box. There is one that won't do anything at all when I press the command
button to do the autofilter. I'm confused because I cut and paste all the code and just changed
some of the criteria for the autofilter for each item. I have looked at the code a million times
(which is only about 8 lines for each autofilter). Every other combination works between the two
list boxes except for when I choose that one item from list box 1. Have I confused anybody yet?
Any suggestions? Does anybody know what is going on? I'll send you the workbook if I have to.
Thanks in advance.



Posted by Ivan Moala on December 04, 2000 7:13 PM

List box items by default start there numbering
from 0 and not 1 ??
Have a look @ your code again to see if it doesn't
reference the index in this manner ??
Other wise post the code


Ivan