Hi guys,

I'm trying to find a solution for one userform action, but I am noy able to and I could not find any support in all the threads I've seen so far.

I have a userform that is suppose to gather activities done by the users. I trigger the used name and the department and have a list of companies based on department. I added buttons to select all and deselect all, but I would need to include another button to select the companies based on their "scope" let's say. Like I want to select, let's say, companies based on the continent they are on. I have lists in a worksheet, one column for each continent, let's say.
My question is: I have the list with all world countries, but when I press the "Africa" button, I want to have selected in the countries listbox all the countries that are listed in the column of Africa in my conditions worksheet.

Can you please help me with a solution for this?

Thanks!