List box not populating with all information

[thmsjlmnt]

I have this current code which works find up to the ConveyorPickingCheck.value part - it populates this information but nothing beyond this?

i'm maybe missing something simple but very frustrating, any info would be great

Please Login or Register  to view this content.

[AlphaFrog]

Hard to say without more details.

One thing to note is if a ListBox1 column doesn't contain exactly "Yes" or "No" (case sensitive and no trailing spaces or extra characters), then the .Values are not set. With your If-ElseIf code, all these would not result in a True or False:
"yes", "NO", "Yes ", "n"

You could use this instead of If-ElseIf...
ToteLaunchCheck.Value = LCase(Trim(ListBox1.List(r, 2))) = "yes"
This returns True if it equals Yes and False if it is not Yes. It's not case sensitive and trims any spaces.

[thmsjlmnt]

I'll give that a shot, thanks, all those if else if did seem a bit bulky aswell