Excel VBA Hack: How To Use Data Mapping In Any Userform
HTML-код
- Опубликовано: 22 июл 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN RUclips MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this comprehensive training, I will be showing you how to create a userform and map that data to the database. We will create the userform and write all the code during the video training.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/UsrformDataMappng_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:36 - Overview
10:09 - Selection Change Event
14:44 - Browse For Product Folder
18:54 - Designing The Userform
32:37 - Add New Product
34:34 - Edit Product
42:28 - Add Product Picture
48:14 - Save/Update Product
55:41 - Save On Exit
1:00:58 - Delete Product
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #userforms #ExcelUserforms #VBATraining #VBAuserforms
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
What timing! I'm working on updating our Inventory workbook and this is perfect. Thanks once again for an awesome lesson
Perfect! For sure you are very welcome
I have been following your videos for some time now and I´m still impressed of what youe can do, easy to follow and easy to understand the code so I can changed to fit "my" needs. You are the king ,thanks, again. 😏😀
Thats great to hear, thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
A great video and explanation on how to make an efficient userform. Thank you!
Thank you so very much, I really appreciate that Jan and so glad you enjoyed it
Here is one of the most wonderful explanations that I have come across, combining creativity and simplifying the difficult. Go on, Sir, you are alone in the field
Wow thanks so much for the great comment. I really do appreciate that
Randy, you are GREAT!!! I love you!
Thanks so much, very kind of you
amazing training! I learned a lot with this training
Great, thanks so much. I am happy to hear that
If you will use Smart Table you wil get dinamic range of table and you don`t need conditional formating row of table. Thank you for this usefull lesson about use user forms.
Yes for sure, I use teables often, however I find ranges have more flexibility and control. I hope this helps and thanks so much.
This is awesome. Thanks for sharing excellent stuff always
Thank you so very much, I really appreciate that and so glad you enjoyed the video
First of all thank you for one more awesome free lesson...This would be even great if you update this userform form to a multi entry (add product) userform.... Cause if we need to insert 10 new products we need to repeat the process 10 times....
Hi and thanks very much. If you want to add multiple products quickly you can do that directly within the database. I hope this helps and thanks so much.
My favorite tutorial
Thank you so very much, I really appreciate that
Love to see your content. make a video on smartphone installments collection application, the effort will be much appreciate 🎉
Hi and thanks very much. I have some on mobile integration. Please search my channel for "mobile" to see some videos of this. I hope this helps and thanks so much.
Hi and thanks for your reply actually my request is for a monthly installments collection in excel.
Hi and thanks very much. Perhaps you can apply this training: ruclips.net/video/-yohea3u2Z4/видео.html
I hope this helps and thanks so much.
❤❤❤❤❤
Excellent, Great Work
Thank you so very much, I really appreciate that
i seen sevaral time but for better learning need to fille ,didnt acces download may be @@ExcelForFreelancers
Hi If you have tried to download this workbook using the links but had a problem please email Angela@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
thank you.
For sure, you are very welcome and I am happy to help and share
Wow. very nice. I'm trying this with dates, but somehow the date gets converted to US notation m/d/y. How to prevent this and only get the date provided in the form, without excel changing it? Thsnks...
Hi ad thanks Mark. You can force the format when inside the field such as
Me.Field3.value = Format(Me.Field3.value,"dd/mm/yyyy")
Just update the field names and this can be done on the Exit event of any field
I hope this helps and thanks so much.
Great video as always!
1 question, when you make a change for an existing product as soon as you exit the field, shouldn't that revert back to the original value if you click on Cancel? If not, then the Save button really doesn't do anything, as the changes have already been saved.
Hi Ron, correct, you would either implement the 'Save' button OR you would use the save on change, but not both. I am just showing you both methods in this video however you would only want to use one in your applications. If i wanted to use both I would only have the 'Save' visible for new products and not for existing ones. I will show you how to do this in the Patreon update next week. Thanks for bringing this up. Much appreciated.
Hi Randy - do you do any tutorials that are compatible with Mac please as User Forms is not available :(
Hi and thanks very much. I have not used a Mac with excel, so some of the trainings would not be compatible. I would suggest using Parallels inside your Mac so you can use the PC version of Excel here: www.excelforfreelancers.com/go/rwm-parallels-YTDesc
Thanks
For sure, you are very welcome
Your explanation is excellent and distinctive, but I face a small issue. How do I deal with the row if it already contains data, and I only want to add the missing data, which will be empty in the textbox? And how do I skip deleting the existing data? When click save in the userform
Hi and thanks very much. You can run an if/then statements such as
If WorksheetName.Cells(YourRow,YourCol).value = Empty then WorksheetName.Cells(YourRow,YourCol).value = FormName.Field1.Value
This should work just update the sheet name, form name and field names.
I hope this helps and thanks so much.
Hey Randy. How do you make the dropdown lists dependent on each other? That is, if I select, for example, a year in list 1, then list 2 will have years, and if I select a month in list 1, then list 2 will have months? Here we cannot use the RowSource field.
HI and thanks very much. I show you how to create dependent drop down lists in Userforms in this training on our Patreon Platform for Quantity Discounts: www.patreon.com/posts/quantity-pos-106777872
I hope this helps and thanks so much.
Great software, I really love it but I would like to add the idea I came up with, how about you add a print button to the userform?
Hi and thanks very much. You can add a print button to a userform however you can only print the contents of a sheet, not userform. I hope this helps and thanks so much.
@@ExcelForFreelancerscan it also print the image of the contact list too?
Yes for sure, just put your contact list on any sheet and it can be printed.
I hope this helps and thanks so much.
Discovered you channel recently, WOW, going through your video (again +) at the 8 minute line, I can't get the highlighted row to change when I replace the number in L2, like the video, what have I missed, also doesn't change on your downloaded workbook ??
Also
If I even get this all into my workbook, how can I populate the boxes etc on a multipage userform
HI and thanks. Please check the conditional formatting. I also have a specific video on that here: ruclips.net/video/6Qgy1XVJYhY/видео.html
I hope this helps and thanks so much.
FIXED, the conditional formatting I followed was correct, the problem was the Excel settings, not sure how it had changed .
Under Option, Formulas, Calculation options. It was set to "Manual", changing it to Automatic except for data tables. Fixed the problem.
HI Malcolm, Thanks for the update and glad you were able to get it fixed. Thank you for your Likes, Shares & Comments. It really helps.
Nice mapping data... I need delivers, courier daily performance, returns shipment to station and few more option data base, so let me know if you have that any kind of data base?
😂
@@edwinmiranda4005 kindly tell me... If you have...and how much you will charge
Hi and thanks very much. I do have a Mobile Delivery Manager which may be helpful here: ruclips.net/video/WRIBkgF61rc/видео.html
I hope this helps and thanks so much.
Hello Randy, do you have any userform video which helps to have selection menu as well so that multiple data can be updated in One go?
Hi and thanks for your comment. I am not sure of the request however there are a lot of userform features in this training that may help: ruclips.net/video/9biCBLwEngM/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers I meant to say that if the user wants to update some values in multiple cell ( same value) then how can be done in listbox?
Hi and thanks, yes sure. I do cover it in the video I have shared with you, with the POS Userform. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello Randy. Need your quick suggestion on one thing. I am using a userform and adding labels in it. But unfortunately the issue is when I open that form from desktop it is perfectly working but when using the same on laptop the size gets different. How can I fix this and have same size across all screen?
Hi and thanks, that is a good question. I am not a big fan of userforms, so my solution would be to use the sheet and not a userform. I am sure there is a solution to dynamically size the userform but probably a good amount of code. You may have to search for that.
I have a per minute data report of temperature. But I want to insert the value of each 10 minutes of data in another sheet and create the chart based on this sheet. Is there any formula to move each 10 minutes data to another sheet?
Yes it is certainly possible in Excel, but more than I can explain in a RUclips comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
1:02:20 Hi Randy. I don't think we can use at the end
.Range(ProdRow & ":" & ProdRow).EntireRow.Delete
because this formula will also delete the edit button hidden on the right side. Am I right?
Hi and thank you will want to make sure to hide he edit button before deleting the row.
I hope this helps and thanks so much.
@@ExcelForFreelancers In my case, unfortunately, even the hidden shape was removed when deleting the entire row. Is it a matter of settings / shape properties?
Moving the shape, before the row is deleted, would solve this issue such as
Sheet1.Shapes("YourShapeName").top = Sheet1.Shapes("YourShapeName").top + 200
That would ensure that the shape is not in the row being deleted.
I hope this helps and thanks so much.
please Provide Practice file. Not able to download the practice file.
Hi and thanks i provide the free template on every single one of my videos. You can download this file using the links in the description under the word DOWNLOAD. If you have tried to download it, what issue did you have? I hope this helps and thanks.
Didn’t find
Hi and thanks, please look for the link under
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
Nice video sir
Thank you so very much, I really appreciate that and so glad you enjoyed it