Two columns unique distinct values to listbox

I have two columns and I need to get the unique value, the columns are in different sheets.

I attach an example, but there is an error, it shows me all the values ​​and only the number 7 and 5 should appear in the list box

thanks a lot

Are sure about what you are asking?
1)

I have two columns and I need to get the unique value, the columns are in different sheets.

There's only one sheet.

2)You are asking
Two columns unique distinct values to listbox

I attach an example, but there is an error, it shows me all the values ​​and only the number 7 and 5 should appear in the list box

What do you mean by unique distinct values?

1 IS AN EXAMPLE, ASSUME COLUMN A IS ON SHEET 1 AND COLUMN B IS ON SHEET 2

1	1
2	2
3	3
4	4
5
6	6
7
8	8
9	9
10	10

2 in the userform1 , in the list box appears all the numbers, but I need Appears the Number 5 and 7, they are the only unduplicated numbers

Originally Posted by Trebor76

Hi diegoasm11,

Based on your posted workbook this will do the job:

Please Login or Register  to view this content.

Though my solution works, if jindon does post a solution I would use his

Regards,

Robert

thanks, but if the range are in different sheets suppose sheet1 sheet2

What if there is another 5 in sheet1?

Do you need 5,5,7 or 5, 7?

Hi
As I understand

Please Login or Register  to view this content.

Originally Posted by jindon

What if there is another 5 in sheet1?

Do you need 5,5,7 or 5, 7?

example
1. Sheet1 numbers 1 2 3 4 5 6 7 8 9 10
sheet2 numbers 1 2 3 4 6 8 9 10

the userform in the list box show numbersAttachment 724995

Originally Posted by mohadin

Hi
As I understand

Please Login or Register  to view this content.

thank you very much the code works

My understanding.

Please Login or Register  to view this content.

You are welcome
And thank you for the feedback
Be happy & safe

Originally Posted by mohadin

Hi
As I understand

Please Login or Register  to view this content.

Hi again, if I want sheet one to be the parent list and sheet two to change

example

hoja1	hoja2
1	1
2	2
3	7
4	4
5	9
6	6

In column 1 of sheet 2, the number 3 and 5 are needed, but in list 1 the values ​​3 5 7 9 appear, since 7 9 are what is missing in column 1 of sheet 1, I need them to appear only what is missing from column 1 sheet 1 in column 1 sheet 2

Captura.PNG

should be

Captura.PNG

thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

dont work , types fail

Originally Posted by mohadin

Please Login or Register  to view this content.

amaizing code thanks

Then you must change your profile telling exact excel version that you are using.

It is working on O365.

Welcome any time