I have a userform for users to enter data, which is then populated into the spreadsheet.
This spreadsheet is effectively a contacts database.
In column C there is a company name. As a result of having multiple contact for each company, company names are duplicated when I open the userform with a combobox initialised with:
I would like to somehow alter this code to remove duplicates in column C.
Please Login or Register to view this content.
Any help is appreciated.
Cheers,
nKife
Last edited by nKife; 11-17-2015 at 07:40 PM.
Hi nKife,
Here's one way:
Regards,Please Login or Register to view this content.
Robert
Last edited by Trebor76; 11-16-2015 at 01:04 AM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Here's how you'd do it without relying on error handling, it's a good idea to avoid looping through ranges or using .addItem:
Please Login or Register to view this content.
both methods works perfectly thanks guys!
You're welcome. Thanks for marking the thread as solved and for the rep
Regards,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks