change code of combobox to not duplicate values

Hi people.

Can anyone help me please? I want that the Combox1 don't show the duplicated values. Thanks

Please Login or Register  to view this content.

See if this works? I added some code that I use for Access.

Please Login or Register  to view this content.

Perhaps this:-

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Trabalhadores.xlsm

Hi. It didnt work. Can u people see the file? i Think its more easier to understand.

Thanks

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

Sorry. i tried this code but the combox1 continue with duplicated names. can u send me the file with that modification? Thanks

See attached.

Hi. isn't working. when i define the range on combobox1 properties, the names apears duplicated.
see jpegTrabalhadores.JPG

Don't touch Combobox property in attached file, just click on C1.

Thank you. its working

One more thing please. i would like to move the two comboboxs to Sheet2 but mantaining the lists in sheet1. What i have to change in code?

Please Login or Register  to view this content.

Thanks

Hi. the combobox1 is already working in sheet2, but combobox2 don't work. Can anyone help me? Thanks

Please Login or Register  to view this content.

Sheet2???? where is it?

sorry. i didnt upload the file updated.

Trabalhadores.xlsm

...................

Thank you.

one more question. please. i would like to have a button in sheet2 to run the Reset combobox1 that is on sheet1

How can i do it?

Thanks

What for?

Why on Sheet2?

That doesn't make sense to me.

Originally Posted by jindon

What for?

Why on Sheet2?

That doesn't make sense to me.

Because i want to hide the sheet1. i don't want people change that data.

But i need people have possibility of clean combobox and make a new search.

I already thought another way, that click in button, the system selects the c1 of sheet1. It works but system shows the moves. i already put screenupdating false, but he shows the moves =/ and stays on sheet1. i want he stays in sheet2

i have this

Please Login or Register  to view this content.

i already tried to change but gives error =/

Hi. Problem solved.

Please Login or Register  to view this content.