Excel VBA Hack: How To Use Data Mapping In Any Userform

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:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Required Field Settings
• Automated Custom ID's
• Auto-Product Save Features
• Formarting Currencies

EXCEL COURSES:

EXCEL PRODUCTS:

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

Follow me on my Social Media Accounts:

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:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin

#exceltraining #userforms #ExcelUserforms #VBATraining #VBAuserforms

[DerickPitcher]

What timing! I'm working on updating our Inventory workbook and this is perfect. Thanks once again for an awesome lesson

[michaelsvenson]

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. 😏😀

[mohammedlazharbouznada]

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

[korysnyi_excel]

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.

[caribeiro]

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....

[JanBolhuis]

A great video and explanation on how to make an efficient userform. Thank you!

[ElectromecanicaIndustrial]

amazing training! I learned a lot with this training

[amjadpac]

Love to see your content. make a video on smartphone installments collection application, the effort will be much appreciate 🎉

[rotimioladunni]

This is awesome. Thanks for sharing excellent stuff always

[MarkVogels]

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...

[MightyGamer-xj]

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?

[mohammedlazharbouznada]

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

[rond]

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.

[PWH]

Hi Randy - do you do any tutorials that are compatible with Mac please as User Forms is not available :(

[malcolmt]

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

[prabhatrawat]

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?

[pawel.]

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.

[tumharahash]

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?

[alpeshjadhav]

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?

[pawel.]

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?