Loop through listbox selected items

Hi There,

I'm trying to print labels on a brother printer using their SDK - I've got a simple table up and running where I select the row(s) that I want to print, click the button and it prints fine. I'd like to move to using a populated listbox where I can select one or multiple rows and have it use the selected data to populate the label but I'm having trouble.

Fundamentally I'm getting errors when I try to use

Please Login or Register  to view this content.

I think I may be more off the mark than that however! I've attached a sample book, any help would be greatly appreciated.

Thanks

Thanks for the explanation, I'm getting a subscript out of range error when I try to run that - can you let me know where I've gone wrong?

Bakerman2 - it's giving me a "next without for" error but the for is there, have I messed something up?

Thanks so much, that's great! It wasn't printing with the first row so I changed r = 1 to r = 0and it seems to be good now.

Thanks both for your help!