Hi Dear Friends,
I have database which include Vendor codes, the database will update daily. In this database vendor may repeat many times, want the unique vendor codes in my ComboBox.
Thanks in Advance.
Suresh TP
Hi Dear Friends,
I have database which include Vendor codes, the database will update daily. In this database vendor may repeat many times, want the unique vendor codes in my ComboBox.
Thanks in Advance.
Suresh TP
In addition:
Database range in Sheets("Database") A:A & Combo Box in Sheets("Dashboard")
Hi
Try this code:
I hope this is what you wanted.Please Login or Register to view this content.
Good day...
Click *, if my suggestion helps you. Have a good day!!
Thank u very much.... the problem is solved... meanwhile I recorded a micro, first goto database, advance filter, unique value, copy another location & offsetted the range to combobox.
Ur code is perfect.. thanks once again..
Regards,
Happy that I could help you. Please click the star icon below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks