Excel VBA - Phone Book - Contact Manager - Excel 2010 Part 5

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
Excel VBA,VBA Excel,phone list,phone book,employee contacts,phone contacts,Excel 2010,VBA,Contact manager,Personal contact manager,VBA Editor,Record macros,Phone list,Recording Macros,Userforms,userform,office video tutorial,online PC learning,office tutorials

[OnLinePCLearning]

Hi Mike,
When working within a userform object and you want to reference a control you can abbreviate the name of the userform to Me.control( this userform) If you were to reference the control from a module you would need to use the full reference e.g frmMyUserform.control

kind regards

Trev

[OnLinePCLearning]

Thanks Donald,
Your feedback is very much appreciated.
Trev

[minaemad]

Hi Trevor, it was such a great app I changed to my own demand, really appreciate it but please if you add another video to describe how to protect the workbook while letting the macros work as normal, your answer and solution are always the best

[mikeshavine]

Hello Trevor I have been going through this phonebook course and I just wanted to know why you use ( Me). in your codes and what does it mean.

[BobBrandis]

Thank you so much Trevor. You have put a lot of time into this. This has been such an inspiration to me that I want to absorb all VBA learning that I can. In the phone book data entry for mobiles, the database will not accept leading zeros so mobiles entered as 012345 show as 12345. The problem can be solved by spacing the first four digits. Is there anyway to change the default to accept leading zeros.

[gicelabraham]

Hello Trevor
I love this phone book I got to say that its been real helpful. I would like to add a feature, to see individual employee photo as were double clicking the name to populate below our username...Can you help me? 

[plumedeneko]

Hi Trevor!

I have a question regarding the textboxes below the ListBox. I've remade the whole userform from scratch, and one of the values I need to update is a time value (ex. 4:00 PM). I've placed time in a combo box (because I have a certain set of times that I would like to provide in the userform. On the listbox, the time shows up fine. However the code,

Me.ComboBoxTime.Value = Me.ListBox1.Column(3)

That I have adapted from your tutorials somehow changes the time into a decimal value.

For example, the time 7:00 PM is changed into the decimal value

What do you suggest that I change the code into to keep the format from the listbox?

[nirob]

Hi Trevor, Thanks for your videos. It's really helpful. But i am facing a problem regarding Add button. When i click the add button the edit button should be unable and turn into grey color and the Message Box should come in top of the Phonelist form. But Nothing happen here, what happened is just it unload the form and load it again. I really need your support. Note: I am fully just coping your codes and all name also.

[michaelkrailo]

I have added three more columns to this project and got most of it working fairly well but now I need to format the phone number in both the phone and mobile columns. I tried formatting the columns directly in the database but every time you edit a contact, it destroys the formatting. So that means it has to be formatted after the edit somehow in vba. Maybe similar to this: = "(###) ###-####". Or do each column individually? Also, I would then need to only accept numbers in the txtPhone and txtMobile. I'm still working on it, getting close.

[JB-ules]

hi just want to ask i have an error on this code
findvalue.Offset(0, -1).Value = Me.txtlast.Value error application-defined or object-define how can i fix this

[kewalsvideo]

Delete tab is not working
Sortit word problem "Sub or Function not defined" Msg show please give me solution

[mohammedraisdeen]

Dear Sir, while i am going to Edit Contact will not accept, and show below error massage Compile error - Name argument not found