How to get dynamic unique value for user form comb box from worksheet

[bala04msw]

Dear Experts,

I request you to help me for the following requirements:


There are 3 sheets in the worksheet - Sheet 1(Database) - Sheet 2 (some of the list, use for name define) - Sheet 3 (external database, which is used to get some details for user form) and have developed user form.

I want to get dynamic unique value in the combo box (In the user form) from a Sheet 3 ("D" Column). I have used the below given codes, but it gets value from Sheet 1 "D" Column.

Please Login or Register  to view this content.

Thanks in advance.

[Sintek]

Please Login or Register  to view this content.

[bala04msw]

Dear Mr. Sintek,

Thanks for your kind support and guidance. It works perfectly. Is there any possibility to sort the list by alphabetic order.

Thanks in advance

[Sintek]

Perhaps it is time for a sample upload

[bala04msw]

Actually, in the populated combobox those list of names are not in alphabetic order. I want to populate the list as alphabetic order. Thats all

Regards

[Sintek]

Please Login or Register  to view this content.

[bala04msw]

Perfect sintek.. Thanks a million. I have requested for other error in forum on "row source" issue. If you have anytime... Could you please help me.

Regards

[Sintek]

Glad I could help...tx for rep +