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

[@ExcelForFreelancers]

🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm

[@DerickPitcher]

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

[@ExcelForFreelancers]

Perfect! For sure you are very welcome

[@michaelsvenson2456]

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

[@ExcelForFreelancers]

Thats great to hear, thanks so much. Thank you for your Likes, Shares & Comments. It really helps.

[@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

[@ExcelForFreelancers]

Wow thanks so much for the great comment. I really do appreciate that

[@caribeiro77]

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

[@ExcelForFreelancers]

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.

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

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

[@ExcelForFreelancers]

Yes for sure, I use teables often, however I find ranges have more flexibility and control. I hope this helps and thanks so much.

[@JanBolhuis]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Jan and so glad you enjoyed it

[@ElectromecanicaIndustrial]

amazing training! I learned a lot with this training

[@ExcelForFreelancers]

Great, thanks so much. I am happy to hear that

[@luisenc789]

Randy, you are GREAT!!! I love you!

[@ExcelForFreelancers]

Thanks so much, very kind of you

[@rotimioladunni7761]

This is awesome. Thanks for sharing excellent stuff always

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you enjoyed the video

[@prosantodas9280]

❤❤❤❤❤ Excellent, Great Work

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@prosantodas9280]

i seen sevaral time but for better learning need to fille ,didnt acces download may be @@ExcelForFreelancers

[@ExcelForFreelancers]

Hi If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@pawel.8820]

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?

[@ExcelForFreelancers]

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.

[@pawel.8820]

@@ExcelForFreelancers In my case, unfortunately, even the hidden shape was removed when deleting the entire row. Is it a matter of settings / shape properties?

[@ExcelForFreelancers]

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.

[@amjadpac]

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

[@ExcelForFreelancers]

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.

[@amjadpac]

Hi and thanks for your reply actually my request is for a monthly installments collection in excel.

[@ExcelForFreelancers]

Hi and thanks very much. Perhaps you can apply this training: kzbin.info/www/bejne/Y6rSmZiXaNplkJY I hope this helps and thanks so much.

[@Abutwins]

Thank you Randy, much appreciated. I have a query please. If you have a check box, how would you code it to display a value within the sheet instead of True False value. I have tried different techniques but all to no avail. I changed the field names to checkbox 1 etc.. but i keep geeting an error. Can you help please. Thanks

[@ExcelForFreelancers]

Hi and thanks so much. Checkboxes would not need any change at all. You would still keep the same format as the others. For example you would name your checkbox "Field5" then in your userform Userform.Comonents("FIeld" & DataCol).value = True this works just fine so no different coding is needed for checkboxes 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

[@Abutwins]

@@ExcelForFreelancers thank you again. I will try what you suggested. Much appreciated

[@ExcelForFreelancers]

For sure, you are very welcome

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

[@ExcelForFreelancers]

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.

[@rond9222]

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.

[@ExcelForFreelancers]

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.

[@PWH1968]

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

[@ExcelForFreelancers]

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

[@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

[@ExcelForFreelancers]

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.

[@alializadeh8195]

Thanks

[@ExcelForFreelancers]

For sure, you are very welcome

[@salleinfo6227]

thank you.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@MightyGamer-x3j]

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?

[@ExcelForFreelancers]

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.

[@MightyGamer-x3j]

@@ExcelForFreelancerscan it also print the image of the contact list too?

[@ExcelForFreelancers]

Yes for sure, just put your contact list on any sheet and it can be printed. I hope this helps and thanks so much.

[@hlaffra]

Hi. This userform is perfect for my needs. I've adapted it to suit my needs and it works great. All but one issue though. When I edit an item and browse for a picture, I click on on it and it shows in the Userform perfectly. But, When I go back and try to update or edit it again, the picture is not there. Tried this many times and the picture does not stay. I don't get any error messages or fault notices. I see it in the field box but does not stay in the image box unless i browse for it again. I presume there is a way to fix this.

[@ExcelForFreelancers]

Hi , Thanks for your comment. 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 60,000 Members who would love to help you with this. Thanks so much.

[@prabhatrawat4394]

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?

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.

[@prabhatrawat4394]

@@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?

[@ExcelForFreelancers]

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.

[@prabhatrawat4394]

@@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?

[@ExcelForFreelancers]

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.

[@rnunez047]

My favorite tutorial

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@malcolmt3125]

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

[@ExcelForFreelancers]

HI and thanks. Please check the conditional formatting. I also have a specific video on that here: kzbin.info/www/bejne/bILKqmSOi6-Mnrs I hope this helps and thanks so much.

[@malcolmt3125]

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.

[@ExcelForFreelancers]

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.

[@pawel.8820]

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.

[@ExcelForFreelancers]

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.

[@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?

[@edwinmiranda4005]

😂

[@tumharahash]

@@edwinmiranda4005 kindly tell me... If you have...and how much you will charge

[@ExcelForFreelancers]

Hi and thanks very much. I do have a Mobile Delivery Manager which may be helpful here: kzbin.info/www/bejne/jYOsc56de5tkqMU I hope this helps and thanks so much.

[@alpeshjadhav5698]

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?

[@ExcelForFreelancers]

Yes it is certainly possible in Excel, but more than I can explain in a KZbin 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.

[@ExcelMadeEasy444]

please Provide Practice file. Not able to download the practice file.

[@ExcelForFreelancers]

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.

[@prosantodas9280]

Didn’t find

[@ExcelForFreelancers]

Hi and thanks, please look for the link under ⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

[@meshlife2346]

Nice video sir

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you enjoyed it