Loop/Step backwards through ListBox until criteria is met?

[onmyway]

Hi all,

I have a tricky question (well, maybe not):

How can I "step back"/loop backwards through my listBox until my criteria is met, then trigger the code below?:

This is the criteria: ListBox.List (LLi, 1) <> "Del"

What I am trying to do: Update the last ListBox1.List(LLi, 8) item field that does not have the text "Del" in the ListBox.List (LLi, 1) field.

My Code:

Please Login or Register  to view this content.

Thank you!

[Norie]

It's easy to step backwards.

Please Login or Register  to view this content.

[onmyway]

Hi Norie,

Thanks for the response. It makes sense.

However, I am getting an Object Required error on the line: For LLi = ListBox.listCount - 1 To 0 Step -1

Here is my code:

Please Login or Register  to view this content.

[Norie]

I assumed from your post that your listbox was actually called ListBox, for example ListBox.List (LLi, 1).

[onmyway]

*blush*

Jap, called ListBox1..... There is no emoticon to express my embarrassment.

One more question: How can I stop the Step once the criteria was met and the code ran?

[onmyway]

In other words, I only want the code to run once when the criteria was met.

[Norie]

Use Exit For to, well, exit the For.

[onmyway]

Well, thank you For you help.