Perfect address book for simply fast access your contacts Numbers, Addresses, Reminder, Printing, Tasks, Dialer, Photo, Notes, E-mail, Follow up, Speed Dial. Quality Designed - Quick access your contacts Numbers, Addresses, Reminder, Active Phonebook - Quality software for quick access your Phone Numbers, simply one of the best we've seen. so impressed from your software, well done. Simply the Best Excel Phone Book – Part2. Video 2 – Excel Phone Book.
|Language:||English, Indonesian, German|
|ePub File Size:||27.88 MB|
|PDF File Size:||20.16 MB|
|Distribution:||Free* [*Registration needed]|
Simply the Best Phone Book - Contact Manager This is a VBA Excel series that will develop this fantastic phone contact interface. Everything is managed from. Free Simple Phone Book - Free, light-weight, portable address book for Windows designed to backup your telephone contacts. Contact Management: to save contacts' information, the user simply has to Phone book app · Phone diary free download - Best answers.
You can make a group for family, friends, business contacts, and so on. Whether saved or printed, you can store a lot of contacts in an address book template. Simply print out template pages and compile them into one file. This is in the case of printable address book templates.
For instance, if you only keep contact information on your phone and it might get destroyed. Keeping an address book file on your computer is convenient too. All you have to do is copy the information you need and paste it.
You can be as creative as you want when creating your editable address book templates. You can use color-coding, different fonts, graphics, and such to make your template more fun. You can print one out and save a copy on your computer.
Create your own address book template in Microsoft Excel If you want to start using an address book, you can download an editable address book template from here. Otherwise, you may also want to create your own template to use. Let's say Extractpromo and Criteriapromo on sheet2. The problem I'm facing is when i run my second userform. It renames my dynamic ranges on sheet 2 to Extract and Criteria. Hi Mike, When an advanced filter runs it creates 2 named ranges one for the extract and one for the criteria in addition to your dynamic named ranges.
These change with the data presented. They will not effect the dynamic named ranges.
To view a dynamic named ranges you need to go to the name manager as they is a formulas. You will see the extract and criteria ranges as static in the name box at the top left of the sheet. You will see all of the named ranges in the name manager.
Excel Phone Book – Contact Manager – Excel 2010
You can run multiple criteria blocks or multiple criteria with in the criteria range. It is extremely versatile. Thanks for taking the time to reply. The only problem I have now is running two advanced filters within the same workbook. I'll explain the scenario. I have 2 Userforms in my workbook. Userform1 is your PhoneBook with the date in Sheet1. Userform2 is my own creating but using your method, with the data in Sheet2.
The problem is getting Userform1 and Userform2 to work at the same time. The Criteria and Extract range does not seem to switch between Sheet1 and Sheet2. Is there a way to point the Criteria and Extract to the right sheet depending on which Userform is Initialized? The reason why I want to do this method, is that if you click on Look Up Code and the search criteria box is blank, it still brings out the entire list of data — this will be handy for my users if they do not know what to search for.
In your other projects you have used a different method to look up data Staff Database in this userform if the search criteria box is empty it does not return any data in the listbox. This will allow you to interact with other objects including user forms.
This is not something I would generally do. It is better to call the second user form from the first and then hide or unload the first user form and then add the same options to the second user form. You can explicitly reference the criteria, copyto range and extract range in your advanced filters. Here is an example below here I have used the sheet codename not the sheet name.
Range "C8". BK8" , CopyToRange: Range "BM8: BP8" , Unique: By the use of operators such as the wildcard you can make your search much more explicit and give the user the option to choose whether they want to search containing or perform an exact search.
Referencing the criteria and extract to the sheet name and not code name did the trick! I dont know why I didnt think of this earlier.
Simply the Best Phone Book - Contact Manager
Learning all the time. I lOVE! Hi Gicel, There is a project that shows how to show pictures in a Userform. It will help you to understand the concepts involved. Here is the link. And I'm having error because of this line. Hi Christian, Drng is for column B So the last line should now be the first line of code as this would be the first value entered. Hi Trevor, I appreciate your website, extremely good work. I have an issue with the form; just wanted to know if you could help. When entering data in fields, after I hit the TAB key it doesn't follow through horizontally to the next field instead does a diagonal jump to a field below.
Hi Thomas, You set set the controls tab order by right clicking a selected userform and choosing the feature Tab Order. They can also be set from the VBA ribbon from the View tab. Bet wishes Trev. If Me. Hi Trevor, Thanks for responding to my question so quickly; I'm currently working on another one of your tutorial so ill try than code later. I am having an issue when completing the tasks in Video 4. I enter the code and click add contact but it does not show up in the database and I get Error "Application defined or Object defined error" and it says my error is in the line: End x1Down.
Hi Kaitlin, If you are using the downloadable template the suggestion below will not apply. Check that the name of the control in the userform is named txtSurname. It must be spelled exactly as in the code. Otherwise you could try below.
Add some data to the first line of the data base in the worksheet and then try the code. Trevor, I tried your suggestion of adding some data to the first line and then trying the code but it still says I have an error and need to debug the same line of code. Do you know of any other ways to fix this?
Hi Katlin, if you are using the template provided and have not modified it I would be happy to have a look and identify the cause of the error.
I can be contacted from the contact page of the website. Please supply the information requested. Best wishes Trev. Hello Trevor, Your tutorials are excellent. I have learned so much about excel and VBA working through the phone book project. Thank you so much for all your hard work on this website. After working through the project as suggested everything works perfectly but I seemed to have run into a problem with my modified project with editing, deleting and the double click command.
I would be very grateful if you could just point me in the right direction to solving this error message that appears upon double-clicking the contact: Invalid argument. Never mind Trevor. I solved the problem. Neglected to correct column count in the outdata named range.
I've completed the tour and have also downloaded the full code. My modifications worked fine to begin with, but I ran into problems when adding extra columns.
I want to ad 3 more columns and did the setup in the PhoneList form, adding the ColumnCount to 9. Added the ColumnWidths for the extra columns. Ajusted the code in various places since the ID column had moved and so on. But it did not work. I can add a new contact including all the new fields but only 7 will show.
I can see in the "database" that they get to the right places. I can even see that the listbox makes room for them all. When I doubleclick on a contact I get a "Could not get the Column property. Invalid argument" error from Excell. But it fills the fiels regardeless. When I try to edit I get the "Fields not complete" error.
I went back to your code the full template and added just 1 column. Did all of the above modifications but still same result. Hi Simon, If you are adding columns you will also need to add controls to the userform and add them to the code as will. The reason the list box is still showing 7 columns is because of the dynamic range "outdata" The listbox is populated by a dynamic named range.
You would also need to adjust the listbox properties as show in the Videos. Thank you so much. Seems I had the same problem as Ariel. She found it herself though. I had found all other places except the one in the Name Manager. Just in case anyone is interested, this is the code I used to print my userform. It's quite large and this code makes the form print out in landscape mode so that if fits nicely on a file folder.
The smartest, simplest contacts app
I've checked that page out and as you said the code is quite large. Hi Simon, I have added some simple code to do this in the appendix of the tutorial. Looks much less complicated than the one I found! Will this code print the userform as it appears or just the data from the spreadsheet? I used the revised code at the end of the post for the print button and added a declaration sub at the top of the vba code.
Hi Deleece, Thanks fr the feedback. One of the properties for a textbox is PasswordChar you must have an x in that property. Remove the X from this property to show the numbers. I've had a similar problem that was related to how the cells are formated in the database.
This also caused a sorting problem for me as numbers were saved as text and sometimes as numbers. I went over the database and changed properties for the different columns. At first I even had numbers showing op in scientific format 8.
If you look at the databse and see numbers wrong — then that could be the problem. First of all I'd like to thank you for sharing this valuable tutorial with the world and express my personal gratitude to you. So I started almost from scratch as I built up the GUI, adding ease of use and intuitiveness to it, did some data validation and etc.
And adding your code was the thing that brought life to all this, it was the bloodstream of it all. I was so excited and I wanted to enhance the functionality by adding a second criteria select field which applies a new filter to the pieces of information that the first one shows in the list box.
I am afraid that this is tougher than me and I wouldn't be able to do it on my own.
Your advice will be appreciated on solving this matter. Hi Zlatin, Thank you for the feedback. To add more criteria to searching you would need to understand how an advanced filter works. I have added a link below to a simple advanced filter tutorial.
You would need to add an extra criteria and then adjust the code to suit as well is out an extra control to your user form. I do not do modifications to applications is my schedule does not permit it. It all starts to make sense to me now. You really have a way of explaining things methodically and understandably. I wish you all the best! Fantastic Trevor Was working on a small project and searched the web for answers to what I was trying to achieve.
Decided to watch all your videos on the telephone book, and all the solutions I was searching for are in this tutorial. Although they need to be adapted to my needs, but they are exactly the answers I needed.
Autocomplete missing information.
Can only say a big thanks once again absolutly fantastic site,thanks for all your work you put into your tutorials and educating people like myself. Hi Trevor, good job on the project, my question is where I need to include "include operators to get a unique value. Hi Fredy, Searching by phone number may be an issue if there are spaces in the number. So basically what I'm saying is that your number formatting would have a bearing on the effectiveness of the search.
Best wishes Trevor. Hi Trevor Thank you so much Is it possible to use the Arabic language When a name is written in Arabic and I want to search by first name and typing the first letter of the name and the pressure on "cmdContact" receive an error message Is it possible to search in Arabic, put the first letter only, without the need to write the full name thank you.
Hi khaled, I do not know the answer to your question. You would need to test it in the language of office that you are using.. Thanks for sharing this valuable tutorial with us. I'm new to VBA, but have have followed your tutorials, which are absolutely informative and easy to follow, and have now completed a rough form. I've adjusted the tab order as per one of the above queries — thanks for that. I'd be very grateful you could outline the code to add two or three more boxes on the user form.
Hi Roy, Thank if your communication. Each control that you add to a user form has a set of properties you can access these properties by right clicking the control in the VBA editor and choosing Properties.
You will you will notice a property called Font that will allow you to change the font style and also the size and characteristics of the font.
To add two more controls you will notice on the phonelist sheet that the columns G and H are empty. You could use these two columns to match the two new controls that you add to the user form.
Because the user form runs an advanced filter to extract the data. The two new column headers would also need to be added to the copy to range of the advanced filter columns U and V. You would then need to adjust the parameters of the advanced filter to accommodate the two new columns. Range " N8: T8 " Instead of T8 the reference would now be V8. There is a dynamic named range that populates the listbox in the user form and it would need to be expanded to accommodate these two new columns.
In the properties of the listbox in the user form he would need to add the column count to now accept the new columns If you wish to view them.
There may be a few other things that are necessary but this will get you started and give you some idea of what is happening. Please accept my very best wishes Trevor. Hi Trevor, many, many thanks for your help and assistance with my queries.
I've altered the font and I'll now have a go at adding the additional columns. Your explanation is so clear and helpful. Although I've only read, and worked through, a few chapters I've found this to be an excellent resource for a beginner like myself.
I would urged anyone who is thinking of learning VBA to download this valuable resource before embarking on any other learning aid. Hi Roy, Thank you for the feedback about the book. I am very glad that you have found it useful and instructive.
Thank you for supporting the website by downloading VBA for Beginners. Please accept my best wishes Trevor. Hi Trevor, first i want to thank you for creating these amazing posts, the way you explain everything makes it look so easy.
Much appreciated. Hi Exionpt, I think I understand what you want to do. First of all the listbox that shows the results of the search is populated by a named range that picks up the results of a Advanced Filter.
In this tutorial the advanced filter has one criteria. Advanced filters are truly awesome and you can run multiple criteria and you can add operators to those criteria as to pretty much filter anything that you want.
It is possible to have what is called cascading data in a combo box. So when you select for instance a category then the items will appear in the next combo box or text box that are only the items for category. This is demonstrated in the tutorial below. Hi Trevor, I tried creating 2 of this forms, and each form has its own dump, Worksheet 1,2 but im getting error, seems like when I recorded a new macro the 1st macro will stop working, even I change all the names in name manager and macro name.
Hi Ryan, I am not really sure what you are referring to. Are you working to develop this training project or a modification of it? Yes I am developing this project, but this time I created 2 Forms exactly the same and of course it will dump to 2 different sheets. When everything is working with the first form edit, delete, add, everything , and start with the 2nd form. After the recording of 2nd macro and try if the 1st Form is still running I'm getting this error: Is it because I can only record 1 advance filter macro?
Hi Ryan, "the extract range has missing or invalid field name" probably means that the headers for you filter are incorrect. The Extract range and the Criteria range and the Copyto range need to have the same headers spelling. Greetings Trevor, i have been learning a lot from this phonebook, trying different things, exploring, etc, so thank you very much for that, i have another question, if i want to add another combobox to filter only the first colum Range "B8" and get results right away and then with the cboSelect combobox select any other of the remain colums Range "C8: H8" and in the text box type something to get the results, for example i have names including repeated ones and i want to see only the unique names on the first combobox one each for this i think i need another sort function if i select one i get a list of all those names including repeated ones and then on next box i want to find adresses or numbers in all the names not only uniques and then i type something and hit search how will this work before the transpose since it only transposes after we hit the search button, is the filtering and sorting done all at once?
Do you happen to have a tutorial for multiple comboboxes doing these functions? Hi Exionpt, The filtering in this project is done with an advanced filter. One of the features of an advance filter is to be able to filter unique values.
Here is a link to a basic tutorial on how advanced filters work. You may find it beneficial to have a look through it before proceeding with modifying your application.
This is sameer from India. Can you also please help with the Export to excel command code in the user form? Hi Trevor, once more thank you for your great tips, i think i see it now, something like you explain in your finance calculator project, cascade combos and then use the advanced filter on multiple criteria and get the filtered data results from it, thats the path ill take. Please, I'd like to thank you for sharing this valuable tutorial with the world and express my personal gratitude to you.
Please, I tried to take advantage of the experience and modify the file as appropriate for my needs, but as a result of these amendments me from the View gives me the error No. Hi Khaled, Thank you for your communication. You have not provided specific information. I can be contacted from the contact page for basic help requests. Hi Natalie, You can change the way that the search Works with the advanced filter by the use of the wildcard operator such as below. I'm not sure how this would work with numbers with comma separators.
But it would be easy enough you to test and see. Don't forget to make a copy before you make any changes. Hello, I'm grateful for what you have helped me with. I have one question though. How do I make it search by phone number?
I'd appreciate it if you'd show me where exactly I have to make the change. Thanks in advance. Thank you so much for the time you have put into this. I am devouring your processes faster than I can chew, hence my problem. It is brilliant. I would like to search the database for a key word and return the result to the ListBox1. So far I have developed a txtFind and cmdFindText to put a word in L9 and then search the database for the term but the results won't go the ListBox.
I suspect the problem is the Criteria mismatch but I can't work out what should go there. Exit Sub errHandler: Hi, thx for such a wonderful tutorial, but.. How can I solve that? Hello Trevor and thanks again for such a wonderful program. I combined two of your programs into one and it looks pretty good.
I'm almost finished but when adding a field i get an error code Method or Data not found. I went back twice and followed your tutorial and can't seem to found the error. I appreciate your assistance. Trevor, your work is really an inspiration. Before I always hate excel as I am not familiar with its functions and its capability.
But after watching some of your tutorials on MVB on the many things it can do for us. I was hook and now I love excel. I got this little problem and hope you would help me out with this error message I am getting every time i press get contact.
Data below destination range will be lost. Continue copying anyway? Hi Penioni, It is impossible to tell from the info given. I think that there is a problem with your criteria and criteria header. Check the advanced filter manually from the ribbon and check the results. Every time i did my search on the phonelist form search box, the result of search reads out on my phonelist form search box and is also been duplicated and dump on the interface sheet 1.
Now i don't know why this is happening. The funny is when I open my phonelist form search box on the data base sheet 2, open the data base on the background and did my search, There was no problem.
But when i run my phonelist form search box and on the background the interface page sheet 1 is open and did my search, this problem occurs and the results search shows on the phonelist form search box and is been duplicated and been dump on the sheet 1 interface.
Hi Peninoni, That is is odd?? Are you using the template and code unmodified? Part 3 Adding the advanced filter to the userform. Part 5 We will be adding the code behind these 4 buttons. Features of the Excel Phone Book 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? Here is the basic breakdown of how advanced filters work. The List range The list range must include the heading along with all of the data. The Criteria range. Here are the 3 steps for this project's advanced filter. March 22, at 5: Trevor Easton says: March 22, at 7: April 9, at 6: April 9, at 7: April 30, at 1: April 30, at 6: May 14, at 8: May 14, at 9: A great business tool that I use on a daily basis.
Also great to see new features added regularly! Keep it up!
You rule! Your contacts are a valuable asset. They belong to you. Safeguarding your data is our priority. We believe that the address book is one of your most valuable assets, and Covve has been designed to protect it and empower you as its gatekeeper.
Industry standard bit SSL encryption. All server data is backed up near real time. External credentials, where possible, are not stored on our servers.Here is the completed code. I want to thank you for your help you have given me on the phone book project, I have now added the extra columns and modified in the way that I needed. There is a dynamic named range that populates the listbox in the user form and it would need to be expanded to accommodate these two new columns.
In this tutorial I will show you how to run and record the advanced filter and then to run the macro from a keyboard shortcut. This really just a reset button.