Excel VBA - Phone Book - Contact Manager - Phone List - Excel 2010 - Part 4

Excel VBA - Phone Book - Contact Manager - Phone List -- Employee Contacts - Excel 2010.This is a VBA Excel series that will develop this fantastic phone contact interface. Everything is managed from the userform. Template with the userform can be downloaded below. The VBA code will be added as we go through the tutorials.
Goal: Develop skills in application development.
Features
Filter contacts by all headings
Filter by full or part references
Data is auto sorted
Add data is indexed so no duplicates
Add new contacts from the form
Delete contacts
Edit all or part of the database
What will we learn?
Recording macros
Working with variables
Functions /IF / SORT / OFFSET
Variable advanced filters
Copy and paste without selecting
Application logic

[Jonathanrivera]

Hi Trevor. Your Phone Book Tutorials have helped me, a real begginer, to create and make this userform to comply with my needs. Have a HUGE problem when I enter data. It duplicates my students Have been breaking my head trying to find a code that doesn't let me repeat any entry what so ever. Coudl you help me please. Thank you. Jonathan Rivera(Puerto Rico)

[OnLinePCLearning]

Hi Jonathan,
Go to my website and contact me from the contact form. I will reply and get you to attach your work and have a look at it for you.
Kind regards

[waqasahmed]

hope ur doing great.

can u plz make one video for search engine
where it can search criteria between two dates.
e.g.One userform with

txtstartdate
txtenddate
cmdsearch
listbox1


thanks in advance.

regards.

[randipeters]

very much a beginner.  I have up to part 3 ok but in part 4 I copied everything just like on the sheet but I keep getting an error message "Application-defined or object-defined error.  Checked everything and no go.  Could you Please tell me what is wrong?