vba select listbox item

[spinkung]

Hi

i'm trying to use this...

for i = i to myForm.myList.listcount -1
                If myForm.myList.Column(1, i) = myValueThen
                    myForm.myList.Selected(i) = True
                End If
next

...to select some items in a listbox. I've had this work on another list where the only differerence is the column ref. i used col(0) instead of col(1).

am i doing anything wrong here?

thanks

 

[John Big Booty]

I don 't see where i is being incremented in your for/next loop and what is the starting value of i ?

 

[spinkung]

i is set to 0 and increments at the next statement

 

[jdraw]

Can you show us all of the code?
You need a space before Then

What dioes this represent
If myForm.myList.Column(1, i)?