How To Create Your First Excel Userform In Excel | Step By Step Training

🎁 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 KZbin MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this training, I will take you step by step on creating your first userform in Excel. This will include controls such as labels, text boxes, combo boxes and a picture. The free workbook download contains a ton of great resources on everything you need to get started on Userforms.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/YourFrstUserform_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
4:34 - Designing Userform
27:47 - Select Contact Exit
37:31 - Browse Picture
41:01 - Save Contact
46:07 - Add New Contact
50:30 - Show Contact Form
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
#ExcelForFreelancers #userforms #exceluserforms #userformsinExcel #BasicVBATraining

[@ExcelForFreelancers]

🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

[@sreckoselendic]

Another fantastic addition to the whole basic series. Really enjoy each Saturday when I can catchup … pure magic!!! Many thanks!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@arlenegriffin4523]

LOVE ALL YOUR TUTORIAL VIDEOS. THANKS SO MUCH.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Arlene

[@karimmimoun2482]

Great job 👏 do you have a video for user form when you add the photo automatically created hyperlink in the cells? Thank you for sharing your experience

[@ExcelForFreelancers]

Hi and thanks so much. I have a Contact Manager in a userform that also has a picture here: kzbin.info/www/bejne/m2jXhqadjM1mi9k I hope this helps and thanks so much.

[@user-tr9mg6hz5b]

Hi Randy, great explanation, I love your videos from scratch!!!

[@ExcelForFreelancers]

Thanks so much. These small ones I can do from scratch so I will try to do that in the future as well for the small, basic trainings as they are also very popular so I am really excited to bring them to you. Thank you for your Likes, Shares & Comments. It really helps.

[@SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much for your continued support

[@Angel_Alvarez_Concepcion57]

Excelente trabajo ingeniero gracias por la información y abrazos desde Puerto Rico 🇵🇷

[@ExcelForFreelancers]

Muchas gracias, realmente lo aprecio y estoy feliz de poder ayudar y compartir.

[@happy-bizz2008]

Another very good job ! Congrats.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@faouad44]

Superb. Thank you Randy.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@robertbateman3665]

I always pick up new ideas from your tutorials. A delete contact button would be nice but that can be "homework" for us! Thanks for all you do!

[@ExcelForFreelancers]

Thanks so much Robert. Yes a great idea for homework is a delete button. I am trying to keep these beginner lessons to around 30 minutes but this one already went way over :) Thank you for your Likes, Shares & Comments. It really helps.

[@tobayekaina8610]

Hi Randy thanks for sharing

[@ExcelForFreelancers]

For sure, you are very welcome Tobaye and thanks so much for the comment and feedback as always

[@rnunez047]

¡Gracias! Randy, me encantan los UserForm. Espero los sábados para aprender más de Vba para principiantes, Muchas Gracias por compartir. 🤝🤓

[@ExcelForFreelancers]

Muchas gracias, realmente lo aprecio y soy muy amable y generoso de su parte. Realmente aprecio su apoyo - Randy

[@rnunez047]

@@ExcelForFreelancers usted es mi mentor

[@W3DRM]

Excellent presentation! Also need to add a "DELETE CONTACT" button. I've followed Dan Strong for years now and between the two of you, I've learned a lot about VBA.

[@ExcelForFreelancers]

That is great and thanks so much. No doubt a Delete Contact button is needed, however we were already way over time on this one. Feel free to download the template and give it a try, and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.

[@ryannguyen976]

Randy, I’m really love the way you teach and easy understand. ❤ After I watched I learned a lot…. Can you make other video tutorial for this video to add ons more details ? If it signed up on January, February, March, etc…. It will be on January, February, March, etc…. Worksheet automatically. Searching , Delete, Edit Contacts in all worksheets. Create chart by monthly signed up. Thank you a lot.

[@ExcelForFreelancers]

Hi and thanks very much. I do have a more advanced training already on this here: kzbin.info/www/bejne/bpaopGmjiZ6ij5o I hope this helps and thanks so much.

[@user-hn9zb9wx5t]

THENK YOU

[@ExcelForFreelancers]

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

[@joemanflyer2001]

Seems like this is a good starting point!

[@ExcelForFreelancers]

Great, thanks so much Joe. Thank you for your Likes, Shares & Comments. It really helps.

[@shiningstaradventureclub2284]

Nice work sir

[@ExcelForFreelancers]

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

[@benosborne413]

Excellent training. How can I have the User form on a different sheet as I don't see the value to type in the form if I can just type in the sheet. Only is that I can add a picture. Now delete button for a contact. But excellent form. I am learning so much with the training. Thanks

[@ExcelForFreelancers]

Hi and thanks so much. This userform will appear on any sheet you want, So whichever shee you would like, you can place a button to show the userform. I purposely left off a Delete button and I discussed this in the video as I want you to learn how to delete a contact on your own, as that is your homework. I hope this helps and thanks so much.

[@user-dr9yx5to5q]

This is first comment. Bravo. Keep designing user form. E.g. Consider School Management system using User Form

[@ExcelForFreelancers]

Hi and thanks so much, i really appreciate that. Please check out 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 If you would like to have this in a userform, please feel free to download it and customize it. I hope this helps and thanks so much.

[@AnjanaLokunarangoda]

Can You Do a training for Userform to the invoice with changeable quantity

[@ExcelForFreelancers]

Hi and thanks very much. Please check my Userform POS which demonstrates an Invoice with automated quantities here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 or here: kzbin.info/www/bejne/Z5CQdmRra5eth7s I have also made updates to this template on our Patreon platform here www.patreon.com/ExcelForFreelancers

[@keithstewart1842]

Perfectly explained enjoyed session

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Keith.

[@keithstewart1842]

@@ExcelForFreelancers Now my only challenge is the Mac environment 🙂much of the VBA and Excel functions are non existent on Mac. But once again your training was probably one of the better ones I have attended, really expertly delivered.

[@ExcelForFreelancers]

Hi Keith, thanks for your comment. There is a good site on VBA for Mac here www.macexcel.com/ You may also want to try something like 'Parallels' which will run a PC version inside of a Mac to make your life a lot easier. I hope this helps and thanks so much.

[@sohaibsportstationery2905]

Your teaching method is very fantastic and amazing but I'm not the student of it. But very useful

[@ExcelForFreelancers]

Great and thanks so much. I am happy to help and share

[@scientist100]

You do it slightly different than what i do lol. I use for loop to find the value and then do the replacement or data updating with the new values. The issue comes when you have after update events on some forms. Depending on the structure it gets a bit difficult because as soon as some values change, then you could get an infinite loop 😂 the other method i have used in the past is to check a certain value against the old value and then check against it and after update, it will know that youre updating values, etc.

[@ExcelForFreelancers]

Thank you so very much for sharing your ideas. I am trying to keep these basic trainings as simple as possible, however your ideas are great. Thank you for your Likes, Shares & Comments. It really helps.

[@wadewells7816]

First, THANKS for this beginners guide to UserForms. Secondly, since this is for Beginners, it would be helpful to show EXACLY what ALL default settings/options you have set up, i.e. Option Explicit in the VBA tools. I was able to manually add it to the macro, but would be nice to have our screen match what yours is as we walk thru the exercise (as beginners). Was able to "google" the answer to get it to add automatically now.

[@ExcelForFreelancers]

Hi Wade, thanks for your comment. Yes I cover all of the default settings in this training here: kzbin.info/www/bejne/iIbMg3WLmsaKask I just can't cover the same default settings on every video that I do. I hope this helps and thanks so much.

[@wadewells7816]

Thanks for the quick reply and link to the settings. Perhaps a mention of this link on your 'beginner series' would benefit other beginners as well.?? thanks again for what you're doing to spread insight into Excel. @@ExcelForFreelancers

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much

[@pierrewolter7416]

Thank you for the Video. Every time I type in the Formular in the name manage it says "There is a problem with this formular" It always recommends that I should use an ' before the = I am sure there is a mistake on my site.

[@ExcelForFreelancers]

Hi and thanks, you can use it without the equals however if the name is correct and you are entering it into the row source field it should work fine. I hope this helps and thanks so much.

[@AyushmanThakur-mo3ee]

Hi Sir Ayushman this side Sir i am facing difficulities to understand VBA Codes because of complex code but your last 7 to 8 videos i am able to undersatnd each and every code and also applied then practically but right now i am not able to understand and i am watching this video again and again but unable to understand some points and i am following you from last 2 years and i have seen your a lot application training and i thing you may also faced these difficulities when you started learning VBA so what can i do to make Easy learning VBA and thank you so much for provide this most valuable content free of cost it really helps for excel users.

[@ExcelForFreelancers]

Hi adn thanks so much, you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared

[@jimpiazza6631]

Is it possible to put create a form on a section of the sheet? ie: select a name - then have the name in cell B3, Address in cell B4, Phone in cell D3- etc

[@ExcelForFreelancers]

Hi Jim, I am not sure I understand your exact question, however this solution may be what you are looking for: kzbin.info/www/bejne/hZKXaWOPisZ9ptk I hope this helps and thanks so much.

[@prathmesh_5103]

Hey randy I've become a great fan of you and love your content I know a bit about vba but not in detail and inspired through your vid i want to create Excel based ERPs and Warehouse management software for small business in local as well as freelancing My question to you is outta all those brilliant courses of yours what all should i prefer and if possible can i do it just based on your free KZbin videos Thank you

[@ExcelForFreelancers]

Hi and thanks so much. The course you would want to take would be my Mentorship course, where I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/

[@prathmesh_5103]

​@@ExcelForFreelancers That course is very comprehensive and lucrative but I'm from India and don't have this much money to spend initially on this course Due to the weaker currency.your course which is fairly priced in USA is bit expensive for us. is their any chance that we could get a relaxation for delayed payment I'm not asking discount cause your conntent is the best I'm just asking for some time. I'll pay the entire amt Like once I start earning this is very huge amt for a teenager. I'm very enthusiastic about this and desperately searching for a source which can give me some money so that I can help my mom with finance Tell me if there is any way... Waiting for your positive reply... Thankyou

[@ExcelForFreelancers]

Hi and thanks. Yes i have two payment plans for the mentorship course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ One for 5 months and the other is for 21 months. I hope this helps and thanks so much.

[@mycybersecurity3571]

❤please help me! How can I share excel Marco with other to edit same time?

[@ExcelForFreelancers]

HI and thanks for your comment. To share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s I hope this helps and thanks so much.

[@prabhatrawat4394]

Hi Randy. In the userform series, can you also create videos how can we filter the data and make editable changes. With selection options like if I want to make same changes in multiple rows then I can do it one go instead of doing it one by one. Thanks again for creating such wonderful videos and helping us to understand all this

[@ExcelForFreelancers]

Hi and thanks so much. Yes I have done that in the Userform POS training here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.

[@prabhatrawat4394]

@@ExcelForFreelancers Hi randy due to the folder I want not able to run the macro in the POS userform. Do you have any other video which I can refer to debug and understand the editable userform?

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

[@twarren3685]

Can this be written for use on Sharepoint?

[@ExcelForFreelancers]

Hi and thanks so much. This works only in a desktop version of excel however to share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s

[@Angel_Alvarez_Concepcion57]

Greetings engineer, how can I download the photo file for the first userform project. Thank you

[@ExcelForFreelancers]

Hi and hanks so much I make these pictures available on our Patreon platform here www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@pawel.8820]

Hi Randy. Could you please create a useform with dynamic dependent comboboxes in your next video? It would be cool if they were dependent 2-3-4 levels (2 is dependent on 1, 3 is dependent on 2, 4 is dependent on 3).

[@ExcelForFreelancers]

Hi and thanks. I have something similar here that can be adapted to a userform kzbin.info/www/bejne/iqC7kpJpfNBjosU I hope this helps and thanks so much.

[@pawel.8820]

@@ExcelForFreelancers thank you very much!

[@TomStoutPhotography]

Is there any way to create Userforms in the MacOS version of excel?

[@ExcelForFreelancers]

Yes for sure, Mac's have userforms, however you cannot add ActiveX controls. You are better off using something like Parallels, which allows full windows inside of a mac here: www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.

[@AyushmanThakur-mo3ee]

sir i have 2 question 1- Why did you use 2nd hidden Fld for picture path what it's work 2- why did you write (*.jpg;jpeg),(*.jpg;jpeg) this two time i understand why did you write firts one but i didn't understand 2nd one so please explain Thank you..

[@ExcelForFreelancers]

Hi and thanks for your comment. The hidden field stores the picture name/ path in order to insert the picture into the form. Also we would only need one instances of each file extension and not 2. I hope this helps and thanks so much.

[@brokenbird2012]

Thanks for the Tutorial. I have not received the download email. Tried several times but no email yet.

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

[@jualflowswitchhargamurah5273]

I don't understand why in my userform when I fill in the Row Source property I can't use the RangeName that has been created?

[@ExcelForFreelancers]

Hi and thanks make sure there are no special characters or spaces and also make sure it is spelled correctly. You can try putting an = in front of it however it should not make a different. Try renaming your named range. Make sure the control is a Combo box control as well 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

[@Tesonics]

Men...This is just sooooo Good. REALLY awesome..... You nailed it. men... .You just TOTALY nailed it.. Thank you SOOOOO MUCH !!!!!!!!

[@ExcelForFreelancers]

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

[@AyushmanThakur-mo3ee]

Sir i am not understanding that why did you take Hidden Field for contactName and Picture path like what is the work of it and what we will know by thid hidden fields.

[@ExcelForFreelancers]

Hi and thanks, The field is hidden since it is not needed. When you combine the folder with the picture name, you have an entire picture path, this is used to insert and display the picture. I hope this helps and thanks so much.

[@FaktaLain_YT]

I watching you

[@ExcelForFreelancers]

Thanks so much. Very kind of you

[@justinwduff]

I'm getting a strange error where after adding the new contact and closing the Userform (using the X), my Excel crashes. Any tips on troubleshooting this?

[@ExcelForFreelancers]

Hi and thanks for your comment. You can try adding this code into your userform code. Private Sub UserForm_Terminate() Unload Me End Sub This will clear the form when its closed via the close x button. I hope this helps and thanks so much.

[@justinwduff]

@@ExcelForFreelancers Thank you for the reply. In the end, I copied the macro into a new file and have not had the issue. By the way, your content is excellent! Happy I subscribed!

[@ExcelForFreelancers]

Great to hear that Justin. I am so glad you enjoyed it. I just completed an add-in that allows you to share & sync any workbooks with anyone in the world. Thank you for your Likes, Shares & Comments. It really helps.

[@connief2679]

Hi. I just discovered that UserForm isn't available on Excel for Mac (2023). Does anyone know a workaround?

[@ExcelForFreelancers]

Hi and thanks, the best workaround is to use Parallels which will mimic a Windows Environment inside a Mac. More information that here www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.

[@connief2679]

I just found this video from Randy: Creating Data Entry WITHOUT Userform kzbin.info/www/bejne/iZ-kZJaZqZJlf68si=5oatlyc-9FdJUs2P. Can't wait to check it out! Thanks, in advance, Randy!! 🙂

[@AyushmanThakur-mo3ee]

Sir how to enable hot keys like when you write IF then is comes End IF automatically and i always forget to write END with or end if so how can i enable hot keys. Thank you...

[@ExcelForFreelancers]

Hi and thanks so much. I show you how, along with a free download, in this video: kzbin.info/www/bejne/nZzQmoGhl9ujoac I hope this helps and thanks so much.

[@AyushmanThakur-mo3ee]

@@ExcelForFreelancers Thank you so much Sir.