fill combobox with unique values.

[ali84pk]

Dear Experts,

I have below code to fill combobox with unique values. This code works only if data is in same sheet of combobox. My data is in sheet1 and combobox is in sheet2. Can some one please modify this code as per my situation.

In addition please write some descriptions also, to understand this code for me.

Thanks in advance

Please Login or Register  to view this content.

[pike]

Hi ali84pk
This will add the unique values from sheet one to the Dictionary
By adding meaningful names to the Dim's will make the code easier to follow

Please Login or Register  to view this content.

[ali84pk]

Thanks Pike, It works perfectly!!!.

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[snb]

The same effect with:

Please Login or Register  to view this content.