So Randy.. this video is excellent.. and I much prefer walking through the building process with you step by step vs. only interrogating an already built solution. While it may take longer to create and or view the video, I think the learning is elevated by seeing and experiencing the construction live.. including mistakes.. which we all make. I find that I can pause and replay the passages that need emphasis. All in all, the take away is much more valuable and engaging than just being an audience to an explanation of an existing end product. I highly encourage more of this type of tutorial. Also, I'd like to salute you for being so generous and sharing your unbelievable and impressive EXCEL skills. Getting an insight into your techniques and creative solutions is invaluable. Thank you and Thumbs up!
Thanks so much Wayne. My first few videos were like this, then I kinda got away from it to try to create more complex applications. But based on the high views of this video, I really must return to this style of teaching, in some instances, since I believe it is easier to learn. It's a fine balance between people who think "yeah i know these steps already" to those who are thinking "oh wait, how did he get to that step?" I plan to release some comprehensive courses in the near future that get deep into the training and feature of large applications such as Reports Dashboards, Accounting, Scheduling, etc. Thanks so much for your extremely valuable feedback.
Hi Randy.. thanks and understood. I use the RUclips playback speed to go faster or slower through sections that I feel I know more or less well. Even for something where I think I know the steps, I find that I learn something anyway by watching how a third party approaches it. I get that some might be impatient about that.. can't satisfy everyone. I look forward to your courses. If offered for a fee, I hope you host them on something like Udemy. I've taken a few paid courses there and like the interface and overall environment. If offered for free, well.. even better for all of us consumers out here. EXCEL is like a gold mine.. the deeper you dig, the more value you get. Thanks again for your generosity with the free tutorials.. much appreciated and I'll definitely consider your paid courses in the future, if that is how they are offered. Thumbs up!
@Wayne, I agree totally, couldn't have said it better myself. The learning is seeing it come together step by step. It is much easier to follow along then trying to check after completion all the code and how it all interacts.
Hi Wayne, thanks so much for your response. That helps me determine how to approach new training so I can better serve people. The courses will be comprehensive 15 - to 20 hours and I will host them on my own website (www.ExcelForFreelancers.com ), however it will be very similar to the Udemy format. I will make sure to set them at a very fair price, and to include a ton of value. Thanks again for your valuable feedback :)
I just created my own data entry forms. It was so easy to adapt the details to my needs because everything was so well explained. Thank you soo much. You are doing a great service. To give something this amazing for free is nothing less than a service.
One minor thing to remind people about: If you're going to have "Delete Record" delete an entire row, be sure all data mapping, and all variables in columns A & B get stored above the actual area where the records reside. Otherwise, that information might accidentally disappear; especially if those rows & columns are hidden.
HI and thanks so much. Within databases, I use row 1 for the data mapping, but yes you should be careful if you delete rows or columns, data mapping must be updated.
Could hug you right now if I could :) In an amazing tut you have answered a gazillion of questions which were bugging me. It's awesome to have a project commonly needed by perhaps millions of people, explained fluently, coherently, in an easy to follow language and step by step manner. This is the kind of course i would enrol in. Thank you very much for your tutorial.
WOW! Thanks so much for your great comment. I am so happy to help you learn and grow. Excel is like a blank canvas and we can great our own art right on it, and provide solutions to common problems in the world. (at least that is the way I see it) I will have some comprehensive courses coming out soon so stay tuned. If you have not done so yet, please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Great tutorial/video. I used it to make a quality analyst form for work, and I loved it. Never touched VBA before this, and it was easy enough to follow. Thank you!
Hi Randy, Great instructional video. I added the following line .Range("E5").Activate into the Sub Cont_New section as I found it easier when adding a new customer to save the user having to click on the yellow field. I'm not sure if it's been mentioned elsewhere but I found it particularly useful from a data entry viewpoint. Keep up the great work, I've learnt lots from your videos. Thanks, Tony, Australia
Hi Tony, thanks so much for your comments, feedback and suggestion. I will also add it to my version so that anyone who downloads this in the future will also get this benefit. Much appreciated.
Thanks Ian I really appreciate the feedback. I realize I must do more of the Build From Scratch in future videos. This one was not so complex so it was a bit easier, but the more complex ones would probably be separated over multiple weeks. Many people seem to agree with you, so your feedback is super helpful. Thanks so much.
Thanks Randy. This was excellent. Really enjoyed the step by step creation. This free content is incredibly valuable. There are many concepts and ideas shown here that can apply to many other excel macro applications. Thanks again.
For sure, you are very welcome and I really appreciate your comment and feedback. I realize this format of starting from the beginning is very helpful so I will continue to do more of this style of training.
Hi thanks so much. I do appreciate that. I realize i must do a lot more 'from the beginning' as people seem to really like to watch every step. I thought it might be a bit boring, but seems to be popular. Thanks so much for the feedback.
Thanks for the great tutorial! Learned very much. I would like to ask if a placeholder frame (rectangle) for the picture in the sheet itself would make it easier to load the specific size of the picture and set the desired location rather than in the macro
HI thank you for your question Xavier. I don't think a frame would help however you would just want to determine the maximum width and height of a picture, then use those max values to set the picture height or width depending up which is greater, and maintaining the aspect ration.
Followed this remarkable video that revealed a real 'how to' guide in creating a well controlled functional application. Thank you for this explanatory video and commenting.
I enjoyed this video a lot. Like many replies here I will also implement some of your ideas on my designs. I only have a few suggestions for you: 1- Whenever you refer to some involved steps, put a link to a separate video (or text file) that describes how to perform that step in more detail. That way you save time in the current video. 2- Why not label the different ranges and use those labels in the formulas and macros?
HI thanks so much. I often do used named ranges right in the VBA, In the Employee Manager Series this is quite common. Thanks so much for the comments and suggestions.
Wow, awesome. I love excel, and manage to stumble along, but you clearly have this down to an art! Always a pleasure to watch you! Keep up the great work & thx again!
For sure you are welcome I am happy to share that. I also programmed for many years without figuring out how to map data like that. This has also saved me tons of programming time. I am happy to help.
I was sceptical this VBA program will work on older Excel 2007. I follow and key in the code as you show. And in the process doing a little bit code modification to suit me. Wow, I am speechless, all the codes works on older Excel 2007. You guys are really fantastic. Thanks a lot. I was wondering before how to use the methods and objects in the VBA. You guys utilise and shows how to put it to use all the methods and objects. Will be learning other things later from your other videos.. Thanks again for making all these wonderful videos.
Hi Danny, thanks so much for your comment. I use Excel 2010 to create these applications and almost everything will work in 2007 that will work in 2010 (excel grouping shapes and Active X objects together) That is new and was introduced in 2010. I want people to be able to use the tricks and techniques I teach regardless of the Excel version they are using. Thanks so much.
I was actually looking to learn VB from scratch but couldn't take my eyes off till the last. Really awesome man. It was really fun watching it. You are a great teacher. It looks far too advanced. It will help me in future. If you could help me with a link from where I can start learning the basics. Thanks Randy.
Hi Rajesh, thanks so much and I am really glad you liked the training. My channel tends to be a bit more advanced however channels such as "Excel VBA Is Fun" is a great way to start learning VBA from the beginning. I also have some courses taught by others on this page here: www.excelforfreelancers.com/partner-courses/ Thanks so much.
I really love this video. Thank for your showing for start to the end. Mr. Randy, You're really amazing teacher I've ever seen. I've learned so much from your video and it really help me with my business. Thank so much for your sharing.
Thanks so much Jim, I really appreciate your comment. Check out our latest series, Employee manager for more comprehensive designs and features right here in RUclips
@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в
Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв
This is very useful. I am new to code and I am loving your lessons. Right now I can take a code and manipulate it but I am unable to write it from scratch. Learning as I go though.
Excel For Freelancers oh yes, it sounds great, we’re quite close. now i’m living in Sai Gon, however, Da Nang is my father’s hometown. I think you’re facing a tough time there, right? Da Nang is now a corona disease spot :(
Amazing! The data mapping Technic you use added a new dimension to how I was coding my Student Tracking application. Thank you so much. Subscribed and am looking forward to seeing more of your expertise. =8)
Great tutorial, thanks for all the hard work. I had a question though. If you were adding loads of new contacts, and tabbing between fields, how could you make it so that after adding the email field for each new customer, then the next 'tab' would highlight the 'add new contact' button so you can just press 'enter' on the keyboard instead of having to use the mouse?
Hi Steve, thanks so much for the comment and great question. In this training I show you not only how to tab through fields but buttons as well, allowing you to run these macros without ever having to touch your mouse: ruclips.net/video/AbML7XS7LJs/видео.html
A note for those who are viewing this video for the first time... Excel For Freelancers has another Contact Manager training...even more advanced tips and techniques!!! HIGHLY RECOMMENDED!!!!
Hello There Mr. Randy, I followed your tutorial step by step and it really helps me a lot, now i can monitor our employee's information whenever there is a change in the data.... my concern now is to add search and edit button and execute it at the same time with a code for me to easily find specific employee, can you make a video or in any other way, how to add this buttons and make it executable.... Your kind help will complete my workbook and implement it in our office... Thank You.
Hi and thanks so much. I have a Search feature in which you can copy in my Employee Manager series right here: ruclips.net/video/tRl6q1DIeWc/видео.html
Hi! thanks for this tutorial vid, but I keep on having an error on H7 & H9 on first row of the data saved, they alternately change every time I save a new contact. honestly I am new in VBA, I just copy your work. so im having a hard time figuring out what is wrong on my input.. thanks a lot! kudos!
HI Michael thanks for your comment and I am glad you found our channel. We do have an Excel For Freelancers Facebook Group here: bit.ly/groupexcel If you can create a post and add your screenshots of the issue and your modifications we can help you through the bug. Thanks so much.
Thanks so much Robert, I really appreciate that. I think i am OK with designs but i have seen some people do amazing jobs with colors and designs. I also have a great dashboard you might be interested in the Employee Manager series here on RUclips or a full course here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass
Awsom job sir we talked about that before 4 months I think and you make special video for people who really need this kind of files . good luck Mr Randy .
Yes very true. Since you have already seen so many of my videos, this idea was not new, but I realized with great feedback from people like you, that I need to start from the beginning and show people every step. Thanks so much.
I really appreciate your video and it seems really good but I know nothing from excel. I will look at it later when I have a more accurate knowledge basis in this program. Thank you!
Hi Leo, thanks so much for your comment. There is a great, basic VBA course you can take here: www.excelvbaisfun.com/ExcelForFreelancers_Discount/ I hope this helps and thanks so much.
The fact that we delete a contact by deleting a row ends up for me with no more lines formated. So instead of "EntireRow.delete" I did .selection; and Selection.ClearContents; and sort the contact board from a to z (not creating a blank row in the middle of filled ones). I would be happy to know an easier way to do that. Thanks Randy for this usefull knowledge shared! I am currently using this video to make a Seminars multibilling platform for valet car park at work.
Hi Corentin, thanks so much for the comment and feedback. Clearing the contents and then resorting the table can work just great, as long as you don't mind the order of your data changing. This may be better as it won't affect things like conditional formatting and named ranges. I hope this helps and thanks so much.
अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का एक्सल में एक्सैस में एचटीएमएल में कोई विडियो नही बना है अतःआप एक फार्म ऐसा बनाये जिसमें आई डी हो, स्वयं हो ,पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत कुछ लिखा जा सकता है परन्तु अपन को पारिवारिक रिलेशनशिप सम्बन्ध लिंक बनाना है वो इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना
Excellent video and a very effective way to teach...real-time. I learnt s lot. I have created one easily for my business in under a week (with a few additional features.). Thanks a zillion.
Hi and thanks so much. After I finish this Employee Manager series I am going to try to do a lot more videos where I start from nothing. I can see that most people enjoy learning as I create them. It takes a bit longer in the planning stage but i see that its super important. Thanks so much
That's one of the most important parts of training a new person on a subject because it helps everyone with the logical operations. Also you talked about the auto hot keys you used. Did you do a video on them yet? Thanks
This is really awesome, I've tried it and modified some data and actually worked! could you also teach us how to edit and save if I want to edit the contact list? I've tried to code but it didn't work.
Hi Kaiser, thanks so much for your comment. Here is a great training that will show you how to edit and save data: ruclips.net/video/Ry3PYTMbskg/видео.html Thank you for your Likes, Shares & Comments. It really helps.
Thank you Randy for this video. Easy to understand though I am new in creating Macros. I was just looking for some videos on creating forms but for a beginner like me this one seems a bit easy to understand. I can just download the FREE Data Form. Again thank you.
Thanks so much Daniel, I appreciate that so much. There are still those who say I move to fast, but I always try to find a happy medium. Thank you for your Likes, Shares & Comments. It really helps.
Randy, I’m so happy to have found this tutorial. I’m interested in buying a version of this contact manager or chatting about having another made. This is the exact solution I’ve been searching for. Is there a preferred way we can discuss?
Hi Joshua, thanks for the information. There is no doubt we can help you with that. This template is free for download however if you want it customized and secured, that can be done. While I cannot take on any projects, I would be happy to refer this to a qualified developer. Can you please email me all your specifications in a detailed scope so I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Wow what an awesome video! It was so clearly explaned. I followed it step by step and it works great! I made into a table so I can use filters and that works fine as well. Really really amazing! Thank you!
@@ExcelForFreelancers I have one question though, is it also possible to make like a search button? Where you can fill in for example a name and then press search such that you get back the information from that person?
Hi Jenske, yes for sure. I have added that already in the Employee Manager series on RUclips, so please search my channel for that video. Thanks very much.
Great tutorial and I loved it so much. One thing I noticed Sir, please correct me if I'm wrong, in the Sub Cont_CancelNew the values of ExistContGrp, NewContGrp, and b3 are not reset but in the video the values were reset. Thank you very much!
HI and thanks for your feedback. I created this application a few years ago, so i would have to check on those variables. Feel free to customize this application to your own requirements. Thank you for your Likes, Shares & Comments. It really helps.
Excellent form table could you extend it with search option? For example if the contacts become hundreds or thousands will be much easier for searching them in some field or maybe some dynamic table and when you search specific group of contacts to show only them there?
Hi and thanks, yes for sure, In fact i have a 'Search By' field set up for just that in this training: ruclips.net/video/YTw1Fek3jzM/видео.html I hope this helps and thanks so much.
Brilliant tutorial. Was inspiration for my software, how do you prevent the user from clicking and changing the data in the table? If you lock it, then you can not access it with VBA also?
Hi and thanks so much. Data can be locked in the cells, however, ultimately the data can be on a different and hidden sheet. I hope this helps and thanks so much.
Thanks so much. I will do my best to speak slower. Try the video I created yesterday. I move a lot slower in this one here: ruclips.net/video/PKbz-1dvhkc/видео.html
I learned a lot thanks for the easy to follow instructions. I do have a question I can’t figure out. When deleting an contact how can you delete or clear just the columns that have the contact information and not delete the Entire Row. I have added a list of data validation items to the right and I keep loosing information from these lists. Thanks again.
Hi Mark, thanks for your comment. There are instances when we want to delete a contact, but not the entire row. You may want to leave the first column (which should be an ID #) with its value in place. You can run a loop from the 2nd column, to the last column, and clear out the contents of the cells. I show you how to do this in this video: ruclips.net/video/aKV5seZmiBs/видео.html I hope this helps and thanks so much.
This is a really walk-through. I added an additional msg box line to the "delete contact" sub, to "double check" that you indeed want to make a deletion. I'm thinking of how to add something similar to the editing feature... you wouldn't want an accidental keystroke to unknowingly allow you to edit a contact.
Hi and thanks for the comment. If I were to turn this into a distributable application I would add protection to the table below so that users were unable to edit any of the table items, and only edited and updated by VBA. I hope this helps and thanks very much for your suggestion.
Excellent Video Sir.... I need some more things to be added ( Login : USER/PWD) , Multiple pictures for Each Contact ( the image should open bigger in the open space right side .)
Certainly an excellent video to farther MS Excel skills. I Have a question. After clicking on Add New Contact and making entries in the form, if you don't press enter key or tab key after entering email-id and click on Save Contact, the New Contact is added, but the email-id of the previously selected row also get changed as that of newly added contact.
Hi and thanks so much Surinder. Please check both the data mapping and the row in which the data is being saved. You can step through the code using F8 to see where the issue lies. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Dear randy, I am having a small issue, at 47:00, whenever I am saving a new contact, the new contact s appearing at the top of the list and not at the bottom, where a new contact should come. Where I am going wrong, Please guide me. The tutorial has been really helpful.
Hi please make sure your Contact Row (ContRow) is set as the first available row, something like ContRow = .Range("A99999").end (xlup).row + 1 You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so very much, I really appreciate that. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Hi Great Video. Can you teach additional button in case you wanted to edit previous or older entries. What should be the macro script? I Appreciate your kind support.
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
I have learned so much from you and I look forward to learning more. Thank you for being a remarkable teacher and I am very grateful to have you as a teacher. Please help how to edit select data and save after edit ?
HI thanks Kirana, I do appreciate that. You can use data mapping to save changes to the database. I also do the same thing here in this video: ruclips.net/video/CJTUiPsacAQ/видео.html
Going to try this today. Was given a task to make an account profiling checklist for our hotel corporate clients. This would work great! If anyone has a similar template for hotels, please comment below!
Good Day Sir, I really love your video, I really learn a lot, may I ask, what if I need to add the gender and is it possible to automatically separate male from female and in alphabetically arranged? Thank You in advance
Hi and thanks for your great question. It is certainly possible. You are welcome to add additional fields, Once added you can run an advanced filter based on the gender and then add those to list and then sort. Feel free to download the application from the links in the description and customize this yourself.
Hi and thanks so much. This code and function is exclusive to Microsoft Excel. I have not worked with Open Office so I am not sure. Thank you for your Likes, Shares & Comments. It really helps.
Hi, first of all thanks for your great effort and its really awesome example to learn excel VBA. I have one query that after mapping & running the code at 37 minute of video, as i scroll in the table, my tabs didn't get updated although code is same. Kindly let me know about where the issue will be. I think there is missing command which will let the macro run as my cursor move in the table which starts from D13 and update the upper tabs. Kindly point out where i am lacking.
Hi Wasif, Thanks for your comment. I would have to see your code for the scroll. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi Randy, Thanks again for this awesome work. It’s a masterpiece. Can this be used to manage students records for a school? My big brother is still using an archaic form to manage his school information. It sometimes takes him days to get a student’s information. Thanks once again 🙏
Hi and yes, This can easily be converted to students instead of Contacts. Please feel free to download this application and customize it however you like. Thanks again.
Hi thanks so much. I am really glad you liked the training. You can see the video training to automatically tab through cells: ruclips.net/video/40aYorpxPiU/видео.html
Great Talent Randy, I would like to add an update button or when i click on the row and add the new info in the field to add that info in that row. How can i accomplish that. or do you have a video showing that feature i can watch. Thanks :)
HI and thanks you can use the same macro for Save New or Update, You just need an If/Then statement to determine if it is new or existing. I show you how to do that in this video: ruclips.net/video/mQ0ZCVuX6hk/видео.html I hope this helps and thanks so much.
Hi and thanks very much. The online version does not allow macros. Online Excel uses 'Scripts' however these scripts are not as powerful as macros, yet. I hope one day they will be. Thank you for your Likes, Shares & Comments. It really helps.
For sure, you are very welcome, I try to do it from scratch when i can but the training can take be quite long, but I do see the value in it for sure. Thanks so much.
Hi Randy. I have just discovered your site and watched a few of your videos, and noticed that all your interfaces contained merged cells. I find that in most cases (especially, if only in the case of a title row) that Center across selection works just as well if not better, what would be your take om this.
Hello Steve, Thanks very much. I have used both at times however I have found that its easier for users to navigate through merged cells when entering data. In case of a Title both will work just fine. Thanks so much.
I made one for my wife's business and she loves it, ty very much!!!. I also used a date column. Is there a way I could sort the data automatically according to the date as I enter the new data?
Hi and thanks for your comment. Once a new record is entered you can run macro to sort the data automatically and then bring that data from the source sheet. I do a lot of sorting in our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Hello sir I am vishal, and one of daily viewer on your channel. Sir I have gone through the all your videos and found your formatting towards excle is ausome. I am fan fo it. Sir mine working area is an commercial Dept & daily basis I have to keep records of cash,finance case,and other billing details. I am requesting you can you publish a video on the same..?
Hi Vishal thanks so much and I am glad you love the videos. Next month, after I finish the Employee Manager, I will create a video on Profit and Loss. I will also be creating a full course on finances. Thanks so much for your comment.
Randy this was superb, and I have built my own contact form on the back of it, ? obviously its a benefit to lock certain cells after completion so people entering data cant overwrite certain cells on the sheet by mistake. However when I lock certain cells then protect the sheet the macro buttons no longer run, Is there a workaround for this or some vba code that can be added so I can solve this issue.
Hello Gary, and thanks for your comment. IF you would like VBA to make changes to a cell in which you do no want the users to make changes to, you have two good choices. 1. You can Unprotect then Re-protect the sheet within VBA 2. You can protect the sheet in VBA and add xlUserInterface only which allows VBA to make changes to protected cells that the user is not allowed to change. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Hi Randy, Thanks for your workbook,I'm not a programer and I don't have basic programing basic skills. After trying this project, I understood that I was required to learn basic skills first. My worksheet project was reset by error code and I can't solve that problem. But I still intrest ur site for my knowledge to progress in Excel. If u can sugget, please let me know how can I try this project again. Thankful.
Hi Min thanks so much for your patience on this. You can download the application and make whatever changes you want. So please feel free to do that. If you want a basic Excel VBA course i suggest one of the courses on my site here: www.excelforfreelancers.com/udemy-courses-on-sale
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
So Randy.. this video is excellent.. and I much prefer walking through the building process with you step by step vs. only interrogating an already built solution. While it may take longer to create and or view the video, I think the learning is elevated by seeing and experiencing the construction live.. including mistakes.. which we all make. I find that I can pause and replay the passages that need emphasis. All in all, the take away is much more valuable and engaging than just being an audience to an explanation of an existing end product. I highly encourage more of this type of tutorial. Also, I'd like to salute you for being so generous and sharing your unbelievable and impressive EXCEL skills. Getting an insight into your techniques and creative solutions is invaluable. Thank you and Thumbs up!
Thanks so much Wayne. My first few videos were like this, then I kinda got away from it to try to create more complex applications. But based on the high views of this video, I really must return to this style of teaching, in some instances, since I believe it is easier to learn. It's a fine balance between people who think "yeah i know these steps already" to those who are thinking "oh wait, how did he get to that step?"
I plan to release some comprehensive courses in the near future that get deep into the training and feature of large applications such as Reports Dashboards, Accounting, Scheduling, etc.
Thanks so much for your extremely valuable feedback.
Hi Randy.. thanks and understood. I use the RUclips playback speed to go faster or slower through sections that I feel I know more or less well. Even for something where I think I know the steps, I find that I learn something anyway by watching how a third party approaches it. I get that some might be impatient about that.. can't satisfy everyone. I look forward to your courses. If offered for a fee, I hope you host them on something like Udemy. I've taken a few paid courses there and like the interface and overall environment. If offered for free, well.. even better for all of us consumers out here. EXCEL is like a gold mine.. the deeper you dig, the more value you get. Thanks again for your generosity with the free tutorials.. much appreciated and I'll definitely consider your paid courses in the future, if that is how they are offered. Thumbs up!
@Wayne, I agree totally, couldn't have said it better myself. The learning is seeing it come together step by step. It is much easier to follow along then trying to check after completion all the code and how it all interacts.
Hi Wayne, thanks so much for your response. That helps me determine how to approach new training so I can better serve people. The courses will be comprehensive 15 - to 20 hours and I will host them on my own website (www.ExcelForFreelancers.com ), however it will be very similar to the Udemy format. I will make sure to set them at a very fair price, and to include a ton of value.
Thanks again for your valuable feedback :)
@krn14242 Thanks very much for your insights. its great feedback to get so I can create more engaging lessons in the future. Much Appreciated!
I just created my own data entry forms. It was so easy to adapt the details to my needs because everything was so well explained. Thank you soo much. You are doing a great service. To give something this amazing for free is nothing less than a service.
For sure, you are very welcome and thanks so much. I am really glad you enjoyed the training.
One minor thing to remind people about: If you're going to have "Delete Record" delete an entire row, be sure all data mapping, and all variables in columns A & B get stored above the actual area where the records reside. Otherwise, that information might accidentally disappear; especially if those rows & columns are hidden.
HI and thanks so much. Within databases, I use row 1 for the data mapping, but yes you should be careful if you delete rows or columns, data mapping must be updated.
Which Code would you use then? I have this Problem
Could hug you right now if I could :) In an amazing tut you have answered a gazillion of questions which were bugging me.
It's awesome to have a project commonly needed by perhaps millions of people, explained fluently, coherently, in an easy to follow language and step by step manner.
This is the kind of course i would enrol in.
Thank you very much for your tutorial.
WOW! Thanks so much for your great comment. I am so happy to help you learn and grow. Excel is like a blank canvas and we can great our own art right on it, and provide solutions to common problems in the world. (at least that is the way I see it)
I will have some comprehensive courses coming out soon so stay tuned. If you have not done so yet, please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Great tutorial/video. I used it to make a quality analyst form for work, and I loved it. Never touched VBA before this, and it was easy enough to follow. Thank you!
Thanks so much Nikki, and great to have you in our Excel For Freelancers Facebook Group as well.
Hi Randy, Great instructional video.
I added the following line
.Range("E5").Activate
into the Sub Cont_New section as I found it easier when adding a new customer to save the user having to click on the yellow field. I'm not sure if it's been mentioned elsewhere but I found it particularly useful from a data entry viewpoint. Keep up the great work, I've learnt lots from your videos. Thanks, Tony, Australia
Hi Tony, thanks so much for your comments, feedback and suggestion. I will also add it to my version so that anyone who downloads this in the future will also get this benefit. Much appreciated.
@@ExcelForFreelancers What is it necessary for?
Great tutorial Randy, it makes it so much clearer actually seeing it built step by step. Keep up the good work.
Thanks Ian I really appreciate the feedback. I realize I must do more of the Build From Scratch in future videos. This one was not so complex so it was a bit easier, but the more complex ones would probably be separated over multiple weeks.
Many people seem to agree with you, so your feedback is super helpful. Thanks so much.
Thanks Randy. This was excellent. Really enjoyed the step by step creation. This free content is incredibly valuable. There are many concepts and ideas shown here that can apply to many other excel macro applications. Thanks again.
For sure, you are very welcome and I really appreciate your comment and feedback. I realize this format of starting from the beginning is very helpful so I will continue to do more of this style of training.
ruclips.net/video/tNHO8PTI4Kw/видео.html
Hi Randy, this is the most relevant video you made until now as you showed us how to build all the things from the scratch. Thank you.
Hi thanks so much. I do appreciate that. I realize i must do a lot more 'from the beginning' as people seem to really like to watch every step. I thought it might be a bit boring, but seems to be popular. Thanks so much for the feedback.
I am in mentorship program. I love all you videos. Great training. Thank you
Thank you so very much, I really appreciate that and great to have you in the Mentorship Program. Much appreciated.
This is really a very good staff, especially building the system from scratch. Thanks bra
Thanks very much, I am glad you liked it. I will continue to build applications from scratch. Much appreciated.
Thanks for the great tutorial! Learned very much. I would like to ask if a placeholder frame (rectangle) for the picture in the sheet itself would make it easier to load the specific size of the picture and set the desired location rather than in the macro
HI thank you for your question Xavier. I don't think a frame would help however you would just want to determine the maximum width and height of a picture, then use those max values to set the picture height or width depending up which is greater, and maintaining the aspect ration.
Followed this remarkable video that revealed a real 'how to' guide in creating a well controlled functional application. Thank you for this explanatory video and commenting.
Thanks so much Geert, As you know I always appreciate your feedback and comments. I am really glad you liked this one.
I enjoyed this video a lot. Like many replies here I will also implement some of your ideas on my designs.
I only have a few suggestions for you:
1- Whenever you refer to some involved steps, put a link to a separate video (or text file) that describes how to perform that step in more detail. That way you save time in the current video.
2- Why not label the different ranges and use those labels in the formulas and macros?
HI thanks so much. I often do used named ranges right in the VBA, In the Employee Manager Series this is quite common. Thanks so much for the comments and suggestions.
Wow, awesome. I love excel, and manage to stumble along, but you clearly have this down to an art! Always a pleasure to watch you! Keep up the great work & thx again!
Thank you so very much, I really appreciate that Victor.
This was excellent. I've never thought to map like this. This gave some me some ideas/direction for a application I working on for my wife. Thanks!
For sure you are welcome I am happy to share that. I also programmed for many years without figuring out how to map data like that. This has also saved me tons of programming time. I am happy to help.
I was sceptical this VBA program will work on older Excel 2007. I follow and key in the code as you show. And in the process doing a little bit code modification to suit me. Wow, I am speechless, all the codes works on older Excel 2007. You guys are really fantastic. Thanks a lot. I was wondering before how to use the methods and objects in the VBA. You guys utilise and shows how to put it to use all the methods and objects. Will be learning other things later from your other videos.. Thanks again for making all these wonderful videos.
Hi Danny, thanks so much for your comment. I use Excel 2010 to create these applications and almost everything will work in 2007 that will work in 2010 (excel grouping shapes and Active X objects together) That is new and was introduced in 2010. I want people to be able to use the tricks and techniques I teach regardless of the Excel version they are using. Thanks so much.
I was actually looking to learn VB from scratch but couldn't take my eyes off till the last. Really awesome man. It was really fun watching it. You are a great teacher. It looks far too advanced. It will help me in future. If you could help me with a link from where I can start learning the basics. Thanks Randy.
Hi Rajesh, thanks so much and I am really glad you liked the training. My channel tends to be a bit more advanced however channels such as "Excel VBA Is Fun" is a great way to start learning VBA from the beginning.
I also have some courses taught by others on this page here: www.excelforfreelancers.com/partner-courses/
Thanks so much.
Thanks for the link. 😊
I really love this video. Thank for your showing for start to the end. Mr. Randy, You're really amazing teacher I've ever seen. I've learned so much from your video and it really help me with my business. Thank so much for your sharing.
Thanks very much for your comment and feedback. Much appreciated. I look forward to bringing you new and exciting videos each week.
Wow this is truly amazing. I had no idea things like this were possible. Thank you very much!
Thanks so much Jim, I really appreciate your comment. Check out our latest series, Employee manager for more comprehensive designs and features right here in RUclips
@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в
Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв
This is very useful. I am new to code and I am loving your lessons. Right now I can take a code and manipulate it but I am unable to write it from scratch. Learning as I go though.
Thanks so much Larry, I am really glad you like the lessons. I look forward to bringing you many more in the near future.
I completely succeeded making those macros and subs, just everything you taught us in the video. Thank you very much. You blowed my mind
For sure, you are very welcome Thao. I am so happy I can help. Cam on em. :)
@@ExcelForFreelancers OMG, you speak vietnamese to me, how kind you are
Thanks so much. I am trying to learn. I have lived in Vietnam the last 5 years, now in Da Nang :) I love it here.
Excel For Freelancers oh yes, it sounds great, we’re quite close. now i’m living in Sai Gon, however, Da Nang is my father’s hometown. I think you’re facing a tough time there, right? Da Nang is now a corona disease spot :(
HI yes still on lockdown here but hopefully over soon. Otherwise safe here and just working. Thanks so much. Great city here.
Amazing! The data mapping Technic you use added a new dimension to how I was coding my Student Tracking application. Thank you so much. Subscribed and am looking forward to seeing more of your expertise. =8)
Thanks so much Dante, I really appreciate that. I am going to add some amazing Automation in Parts 4 and 5 so please watch each week. Thanks again.
Great tutorial, thanks for all the hard work. I had a question though. If you were adding loads of new contacts, and tabbing between fields, how could you make it so that after adding the email field for each new customer, then the next 'tab' would highlight the 'add new contact' button so you can just press 'enter' on the keyboard instead of having to use the mouse?
Hi Steve, thanks so much for the comment and great question. In this training I show you not only how to tab through fields but buttons as well, allowing you to run these macros without ever having to touch your mouse: ruclips.net/video/AbML7XS7LJs/видео.html
This is one of the best excel lesson I've ever watched.... Thanks @Excel For Freelancers
Thank you so very much, I really appreciate that Leandro.
A note for those who are viewing this video for the first time... Excel For Freelancers has another Contact Manager training...even more advanced tips and techniques!!! HIGHLY RECOMMENDED!!!!
Thanks so much. Great idea for the comment. Here is the link: ruclips.net/video/guqUCV31NBo/видео.html
Hello There Mr. Randy, I followed your tutorial step by step and it really helps me a lot, now i can monitor our employee's information whenever there is a change in the data.... my concern now is to add search and edit button and execute it at the same time with a code for me to easily find specific employee, can you make a video or in any other way, how to add this buttons and make it executable.... Your kind help will complete my workbook and implement it in our office... Thank You.
Hi and thanks so much. I have a Search feature in which you can copy in my Employee Manager series right here: ruclips.net/video/tRl6q1DIeWc/видео.html
Hi! thanks for this tutorial vid, but I keep on having an error on H7 & H9 on first row of the data saved, they alternately change every time I save a new contact.
honestly I am new in VBA, I just copy your work. so im having a hard time figuring out what is wrong on my input.. thanks a lot! kudos!
HI Michael thanks for your comment and I am glad you found our channel. We do have an Excel For Freelancers Facebook Group here: bit.ly/groupexcel
If you can create a post and add your screenshots of the issue and your modifications we can help you through the bug. Thanks so much.
I'm at 10 min mark - REALLY ENJOYING THIS... I never was good at DESIGN! In fact I was mocked lovingly at work when I tried to create dashboards lol
Thanks so much Robert, I really appreciate that. I think i am OK with designs but i have seen some people do amazing jobs with colors and designs. I also have a great dashboard you might be interested in the Employee Manager series here on RUclips or a full course here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass
Great video, very detailed and you are not rushing for slow people like myself. can't wait to get a project to build step by step.
Thanks so much. I am really glad you liked it. Much appreciated.
Awsom job sir we talked about that before 4 months I think and you make special video for people who really need this kind of files . good luck Mr Randy .
Yes very true. Since you have already seen so many of my videos, this idea was not new, but I realized with great feedback from people like you, that I need to start from the beginning and show people every step.
Thanks so much.
I really appreciate your video and it seems really good but I know nothing from excel. I will look at it later when I have a more accurate knowledge basis in this program.
Thank you!
Hi Leo, thanks so much for your comment. There is a great, basic VBA course you can take here: www.excelvbaisfun.com/ExcelForFreelancers_Discount/
I hope this helps and thanks so much.
Thank you! I learned lots. You are my hero! My goal is to know as much as you!
Happy to help and thanks so much Susan. Thank you for your Likes, Shares & Comments. It really helps.
The fact that we delete a contact by deleting a row ends up for me with no more lines formated.
So instead of "EntireRow.delete"
I did .selection; and Selection.ClearContents; and sort the contact board from a to z (not creating a blank row in the middle of filled ones).
I would be happy to know an easier way to do that.
Thanks Randy for this usefull knowledge shared! I am currently using this video to make a Seminars multibilling platform for valet car park at work.
Hi Corentin, thanks so much for the comment and feedback. Clearing the contents and then resorting the table can work just great, as long as you don't mind the order of your data changing. This may be better as it won't affect things like conditional formatting and named ranges.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks so much for your answer, best wishes for this new year!
अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का एक्सल में एक्सैस में एचटीएमएल में कोई विडियो नही बना है अतःआप एक फार्म ऐसा बनाये जिसमें आई डी हो, स्वयं हो ,पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत कुछ लिखा जा सकता है परन्तु अपन को पारिवारिक रिलेशनशिप सम्बन्ध लिंक बनाना है वो इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना
Thanks very much for your suggestion. I will try to have the added.
Why did I just watch this entire thing? :D Nice video!
Thank you very much. So nice of you Sniks304
Thanks brother for this super tool for me. I would like add languages spoken by each and good at speaking each of them. Thanks again
Yes for sure and you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Thank you for taking the time to put this tutorial together, excellent!!
You're very welcome and happy to help
I'm here todayy. Can't wait to learn how to do this. Thank you for the great video
Thank you very much. I do appreciate that :)
Excellent tutorial. This is well detailed and easy to follow. great job!
Thank you very much David, I do appreciate that.
Unlimited like thank you for your efforts sir this is the best channel ever
For sure, you are very welcome and happy to help.
Excellent video and a very effective way to teach...real-time. I learnt s lot. I have created one easily for my business in under a week (with a few additional features.). Thanks a zillion.
Hi and thanks so much. After I finish this Employee Manager series I am going to try to do a lot more videos where I start from nothing. I can see that most people enjoy learning as I create them. It takes a bit longer in the planning stage but i see that its super important. Thanks so much
@@ExcelForFreelancers any reason you prefer this to user forms in excel?
Thanks Randy for the walk through on how you put this together.. I really liked this video.
Thanks so much. I am really glad you liked it. I will do more starting with blank workbooks, although i tend to mess up more. LOL :)
That's one of the most important parts of training a new person on a subject because it helps everyone with the logical operations. Also you talked about the auto hot keys you used. Did you do a video on them yet? Thanks
This is what I looking for or waiting for. Thanks Randy, thanks Excel For Freelancers....
You are welcome, happy to help.
This is really awesome, I've tried it and modified some data and actually worked! could you also teach us how to edit and save if I want to edit the contact list? I've tried to code but it didn't work.
Hi Kaiser, thanks so much for your comment. Here is a great training that will show you how to edit and save data: ruclips.net/video/Ry3PYTMbskg/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
Thank you Randy for this video. Easy to understand though I am new in creating Macros. I was just looking for some videos on creating forms but for a beginner like me this one seems a bit easy to understand. I can just download the FREE Data Form. Again thank you.
Hi Rolando. I am glad you liked it. Thanks so much. I am happy I could help.
Thank you for working quickly and concisely. A refreshing change of pace from some that drone on with minutia. (for me anyway).
Thanks so much Daniel, I appreciate that so much. There are still those who say I move to fast, but I always try to find a happy medium. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers I would rather stop and go back than wait for the person to finish explaining.
Thanks very much for the content. You make excel look so easy to the ordinary person. I very much appreciate all your effort.
Thank you very much. I do appreciate that Nana.
Randy, I’m so happy to have found this tutorial. I’m interested in buying a version of this contact manager or chatting about having another made. This is the exact solution I’ve been searching for.
Is there a preferred way we can discuss?
Hi Joshua, thanks for the information. There is no doubt we can help you with that. This template is free for download however if you want it customized and secured, that can be done. While I cannot take on any projects, I would be happy to refer this to a qualified developer. Can you please email me all your specifications in a detailed scope so I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
Wow what an awesome video! It was so clearly explaned. I followed it step by step and it works great! I made into a table so I can use filters and that works fine as well. Really really amazing! Thank you!
Thanks so much Jenske. I am really glad you enjoyed the video training.
@@ExcelForFreelancers I have one question though, is it also possible to make like a search button? Where you can fill in for example a name and then press search such that you get back the information from that person?
Hi Jenske, yes for sure. I have added that already in the Employee Manager series on RUclips, so please search my channel for that video. Thanks very much.
Great tutorial and I loved it so much. One thing I noticed Sir, please correct me if I'm wrong, in the Sub Cont_CancelNew the values of ExistContGrp, NewContGrp, and b3 are not reset but in the video the values were reset. Thank you very much!
HI and thanks for your feedback. I created this application a few years ago, so i would have to check on those variables. Feel free to customize this application to your own requirements. Thank you for your Likes, Shares & Comments. It really helps.
Excellent form table could you extend it with search option? For example if the contacts become hundreds or thousands will be much easier for searching them in some field or maybe some dynamic table and when you search specific group of contacts to show only them there?
Hi and thanks, yes for sure, In fact i have a 'Search By' field set up for just that in this training: ruclips.net/video/YTw1Fek3jzM/видео.html
I hope this helps and thanks so much.
Brilliant tutorial. Was inspiration for my software, how do you prevent the user from clicking and changing the data in the table? If you lock it, then you can not access it with VBA also?
Hi and thanks so much. Data can be locked in the cells, however, ultimately the data can be on a different and hidden sheet.
I hope this helps and thanks so much.
Sir please speak slowly some other country people con not get easily
Great work sir thank you
Thanks so much. I will do my best to speak slower. Try the video I created yesterday. I move a lot slower in this one here: ruclips.net/video/PKbz-1dvhkc/видео.html
I learned a lot thanks for the easy to follow instructions. I do have a question I can’t figure out.
When deleting an contact how can you delete or clear just the columns that have the contact information and not delete the Entire Row. I have added a list of data validation items to the right and I keep loosing information from these lists. Thanks again.
Hi Mark, thanks for your comment. There are instances when we want to delete a contact, but not the entire row. You may want to leave the first column (which should be an ID #) with its value in place. You can run a loop from the 2nd column, to the last column, and clear out the contents of the cells.
I show you how to do this in this video: ruclips.net/video/aKV5seZmiBs/видео.html
I hope this helps and thanks so much.
Thank you so much Sir! 😇 God bless you and your team
😇😇😇
For sure, you are very welcome
Crazy....this tutorial is gold! Thanks!
Thanks so much. I am glad you like it :)
This is a really walk-through. I added an additional msg box line to the "delete contact" sub, to "double check" that you indeed want to make a deletion. I'm thinking of how to add something similar to the editing feature... you wouldn't want an accidental keystroke to unknowingly allow you to edit a contact.
Hi and thanks for the comment. If I were to turn this into a distributable application I would add protection to the table below so that users were unable to edit any of the table items, and only edited and updated by VBA. I hope this helps and thanks very much for your suggestion.
Are you able to use this to search for specific personnel, for example, if you type in the name box and press enter will it pull up related rows?
Hi and thanks. yes for sure. Please check out my Ultimate CRM training for more search features. I hope this helps and thanks so much.
Excellent Video Sir.... I need some more things to be added ( Login : USER/PWD) , Multiple pictures for Each Contact ( the image should open bigger in the open space right side .)
HI thanks we cover the multiple pictures and attachments in our new Employee Manager series (we are on Part 4 currently) I hope this helps.
Certainly an excellent video to farther MS Excel skills. I Have a question. After clicking on Add New Contact and making entries in the form, if you don't press enter key or tab key after entering email-id and click on Save Contact, the New Contact is added, but the email-id of the previously selected row also get changed as that of newly added contact.
Hi and thanks so much Surinder. Please check both the data mapping and the row in which the data is being saved. You can step through the code using F8 to see where the issue lies.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Dear randy, I am having a small issue, at 47:00, whenever I am saving a new contact, the new contact s appearing at the top of the list and not at the bottom, where a new contact should come. Where I am going wrong, Please guide me. The tutorial has been really helpful.
Hi please make sure your Contact Row (ContRow) is set as the first available row, something like
ContRow = .Range("A99999").end (xlup).row + 1
You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Thank you for your Likes, Shares & Comments. It really helps.
Wow this amazing. I had no idea things like this were possible. Thanks
For sure, you are very welcome Wambura. I am happy I can help.
Thank you for putting in so much effort on this excellent video. Keep up the good work!
HI thanks very much and I am really glad you liked it. Much appreciated.
Great turtorial Helped me alot!!!
Excellent!. I am very happy I could help.
What a video, I've still so much to learn 😬
Thank you so very much, I really appreciate that.
I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Great Video!! Thanks for going true step by step, really appreciate!
For sure, you are very welcome, happy to help.
Rguide... best RUclips channel to become excel expert
Thanks so much Dinesh. I really appreciate that.
Yes. This makes it super fast !!
Awesome. Happy to hear that
Awesome video, been looking for this for sometime. Thank you!
For sure, you are very welcome Hanua
Hi Great Video. Can you teach additional button in case you wanted to edit previous or older entries. What should be the macro script? I Appreciate your kind support.
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Thank you so much for this tutorial. It was a lot of fun. Cheers.
For sure you are very welcome. I am so glad you liked it.
I have learned so much from you and I look forward to learning more. Thank you for being a remarkable teacher and I am very grateful to have you as a teacher.
Please help how to edit select data and save after edit ?
HI thanks Kirana, I do appreciate that. You can use data mapping to save changes to the database. I also do the same thing here in this video: ruclips.net/video/CJTUiPsacAQ/видео.html
Dear mr,
Did you have tutorial for point of sale in excel ?
Hi not at this time however it is something that I have on my list to create in the near future.
Going to try this today. Was given a task to make an account profiling checklist for our hotel corporate clients. This would work great!
If anyone has a similar template for hotels, please comment below!
Thank you very much Haroon, I do appreciate that.
Very good!
Welcome to view and give comments. Thanks
Thank you very much. I do appreciate that.
Absolutely Brilliant Tutorial thank you soooo much!!!
Thank you so very much, I really appreciate that Ali
Good Day Sir, I really love your video, I really learn a lot, may I ask, what if I need to add the gender and is it possible to automatically separate male from female and in alphabetically arranged? Thank You in advance
Hi and thanks for your great question. It is certainly possible. You are welcome to add additional fields, Once added you can run an advanced filter based on the gender and then add those to list and then sort. Feel free to download the application from the links in the description and customize this yourself.
@@ExcelForFreelancers Thank you so much Sir 😊. Your are a great help.
This is some Great Stuff Thank you for bringing this video to us I just would like to know If I could do all this in OpenOffice Software.
Hi and thanks so much. This code and function is exclusive to Microsoft Excel. I have not worked with Open Office so I am not sure. Thank you for your Likes, Shares & Comments. It really helps.
Hi, first of all thanks for your great effort and its really awesome example to learn excel VBA. I have one query that after mapping & running the code at 37 minute of video, as i scroll in the table, my tabs didn't get updated although code is same. Kindly let me know about where the issue will be. I think there is missing command which will let the macro run as my cursor move in the table which starts from D13 and update the upper tabs. Kindly point out where i am lacking.
Hi Wasif, Thanks for your comment. I would have to see your code for the scroll. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi Randy,
Thanks again for this awesome work. It’s a masterpiece.
Can this be used to manage students records for a school? My big brother is still using an archaic form to manage his school information. It sometimes takes him days to get a student’s information.
Thanks once again 🙏
Hi and yes, This can easily be converted to students instead of Contacts. Please feel free to download this application and customize it however you like. Thanks again.
Hi there!
Excellent tutorial, Bravo!
I would love to move thru the columns (H5:K9) for data entry by pressing tab, can you show how to do it?
Hi thanks so much. I am really glad you liked the training. You can see the video training to automatically tab through cells: ruclips.net/video/40aYorpxPiU/видео.html
Great Brother : your Videos are very helpful for beginner
I am really glad you liked it. Thanks so much.
Very helpful and creative, thanks for your efforts and everything...
For sure, you are very welcome and thank you.
Great Talent Randy, I would like to add an update button or when i click on the row and add the new info in the field to add that info in that row. How can i accomplish that. or do you have a video showing that feature i can watch. Thanks :)
HI and thanks you can use the same macro for Save New or Update, You just need an If/Then statement to determine if it is new or existing. I show you how to do that in this video: ruclips.net/video/mQ0ZCVuX6hk/видео.html
I hope this helps and thanks so much.
Great tutorial! Noob question...can this be created in the online version of Excel? Thanks.
Hi and thanks very much. The online version does not allow macros. Online Excel uses 'Scripts' however these scripts are not as powerful as macros, yet. I hope one day they will be. Thank you for your Likes, Shares & Comments. It really helps.
Very interesting to see it done from scratch, Thanks
For sure, you are very welcome, I try to do it from scratch when i can but the training can take be quite long, but I do see the value in it for sure. Thanks so much.
Excel lent tutorial I learned a ton. Thank you so very much.
For sure you are so welcome. Quite happy to help. :)
Watch at .75 playback speed. Great Vid
Thank you so much Archie. I am glad you liked the video
Hi Randy. I have just discovered your site and watched a few of your videos, and noticed that all your interfaces contained merged cells.
I find that in most cases (especially, if only in the case of a title row) that Center across selection works just as well if not better, what would be your take om this.
Hello Steve, Thanks very much. I have used both at times however I have found that its easier for users to navigate through merged cells when entering data. In case of a Title both will work just fine. Thanks so much.
Hope you can make also a data entry that can multiple and calculate total. Thanks
HI and thanks so much for your comment. Please search my channel for additional videos to help you with totals. I hope this helps and thanks so much.
Great Lesson
Thank you so very much, I really appreciate that
I made one for my wife's business and she loves it, ty very much!!!. I also used a date column. Is there a way I could sort the data automatically according to the date as I enter the new data?
Hi and thanks for your comment. Once a new record is entered you can run macro to sort the data automatically and then bring that data from the source sheet. I do a lot of sorting in our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Hello sir
I am vishal, and one of daily viewer on your channel.
Sir I have gone through the all your videos and found your formatting towards excle is ausome.
I am fan fo it.
Sir mine working area is an commercial Dept & daily basis I have to keep records of cash,finance case,and other billing details.
I am requesting you can you publish a video on the same..?
Hi Vishal thanks so much and I am glad you love the videos. Next month, after I finish the Employee Manager, I will create a video on Profit and Loss. I will also be creating a full course on finances. Thanks so much for your comment.
Thanks for the great tutorial. I really love this video.
For sure, you are very welcome Azizi
Randy this was superb, and I have built my own contact form on the back of it, ? obviously its a benefit to lock certain cells after completion so people entering data cant overwrite certain cells on the sheet by mistake. However when I lock certain cells then protect the sheet the macro buttons no longer run, Is there a workaround for this or some vba code that can be added so I can solve this issue.
Hello Gary, and thanks for your comment. IF you would like VBA to make changes to a cell in which you do no want the users to make changes to, you have two good choices.
1. You can Unprotect then Re-protect the sheet within VBA
2. You can protect the sheet in VBA and add xlUserInterface only which allows VBA to make changes to protected cells that the user is not allowed to change.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Wow the best tutorial i have learnt alot can you create one for payroll for me Thanks!
HI and thanks I have a Payroll in our Employee Manager series right here on RUclips. I hope this helps and thanks so much.
Hi Randy, Thanks for your workbook,I'm not a programer and I don't have basic programing basic skills. After trying this project, I understood that I was required to learn basic skills first. My worksheet project was reset by error code and I can't solve that problem. But I still intrest ur site for my knowledge to progress in Excel. If u can sugget, please let me know how can I try this project again. Thankful.
Hi Min thanks so much for your patience on this. You can download the application and make whatever changes you want. So please feel free to do that. If you want a basic Excel VBA course i suggest one of the courses on my site here: www.excelforfreelancers.com/udemy-courses-on-sale
Thank you very much ! I expect more video later on !
For sure no problem. I am glad you enjoyed it.
excellent explaination and superb technique. Thank you so much for all of your great videos! Ten thumbs up!
Thanks so much Mohd, I really appreciate that. :)