Populate Listbox with a range from one worksheet (criteria) and remove if item found

Hi Guys,
I would really appreciate some help here.

Regards

Hi Again,

I have tried myself but.... at least most of it works..

If anybody would like to help I will upload..

Thanks

Bump kindly...

It would be nice if someone just said something

Hi, Foreverlearning. An example file you attached is not clear. Maybe you can create a different example?

Hi nilem,

Thank you so much for replying.......

I have attached another example with more detailed notes within.

Regards..

try it (see attached file)

Thank you very much nilem...

You have made me very happy mate...

I would have to spend hours understanding your level of arrays...

I have made some notes within file to explain a few things you mentioned

mate you deserve a pat on the back and of course much more....

Regards
Lionel

Hi Lionel. This is a very long time to prescribe all the codes for your forms, so I slightly modified your code and put a sample file from John Walkenbach, so you are able to do what you need.

Hi nilem,

You have made me very happy mate in what you have done to date.

I need to ask a few questions to understand what is happening in the code

What does the & part mean when you declare variables

Please Login or Register  to view this content.

Another issue is when the Task Set 15 form loads the 5 Listboxes are full of blanks and you can click on each one

Regards
Lionel

& - is the abbreviated name of the variable type. & means Long, % - Integer etc.

Listboxes filled in this procedure

Please Login or Register  to view this content.

and if your range F38:I42 empty, Listboxes will also be empty.

Hi nilem,
Thanks for your explanation of variables.. (Learned something new)

As for Listboxes.. I step thru the code and yes it does bypass empty cells but when form is loaded each listbox has selectable blanks
as in attached picture. No extra code has been added.
Listboxes.JPG

Creates an issue because when I try to add to listboxes the value goes to bottom of 5 blank listbox items
and these can be deleted with a remove item.

How can I get rid of these as form loads

Thanks
Lionel

I think I understand now.
try

Please Login or Register  to view this content.

Just beautiful mate, just beautiful.

What I need to know if not too much trouble (Sorry but you are helping me but also teaching me)

When I populate the same form listbox with names that any names in the five listboxes are removed from the large left one on loading form

I still can't believe a chap from Russia is helping me way over here Down Under

Thanks
Lionel

Well, try this

Please Login or Register  to view this content.

Thanks Nilem,

I will go thru and learn what you have given me..

Have a great day mate...

Regards
Lionel