How To Create A Fully Dynamic Userform In Excel With A Single Macro [Full Training + Free Download]

In this week’s training, I will show you how to create a fully dynamic user form in Excel.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:35 – Overview
12:49 – Worksheet Selection Change
14:13 – Show Edit Icon
14:48 – Show Quick View Form
1:03:37 – Close Quick View Form
1:03:58 – Click Cancel Button
1:04:17 – Save Data

JOIN OUR COMMUNITY:

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!
Thank you very much for your continued support,
Randy Austin

#DynamicUserforms #UserExperience #UserInterface #UserInterfaceDesign

[rebeccamoore]

Learned a lot these past 2 months since discovering your channel. Love how you teach, your energy, your knowledge, and your sharing of that knowledge. I also appreciate Frederik's suggestions and questions below. A thought of my own is how to dynamically generate combo boxes for fields such as State, or dependent combo boxes if you have a field combination like Category and Sub-Category. Thanks again!

[johnnewson]

Just looked at this amazing training from Randy, well done, nice to see how it should be done. will be Experimenting with the text size reference to the size of the label fields and text fields.

[bestscenes]

What an Excellent way to Start the Year. You are awesome Randy. Can't wait for it.

[monsieurcollins]

You are really excellent. this year I want to take a subscription and then show us the great power of Excel.
congratulations to you

[czechyorker]

Reminder set. I like the background- blue waves as well.

[ruffbean]

Another powerful tutorial. To make it even more powerful is that its totally free. You are really cool. I keep enjoying your tutorials and I am beginning to learn a lot from you.

[richardrobertson]

At times I wonder what really Excel can'tdo, you seem to amaze us every time by exposing the power behind Excel, ...thanks you

[jwujf]

Awsome, can not wait to update m earlier tools with this new functionality. Thanks

[gerardbakker]

Very clever Randy, thanks. Always learning interesting stuff from you.

[wildbillpalmer]

Thank you Randy, for another excellent app!

[microsoftsarker]

Wow Thank you so much for this video, what a great help. It works perfectly. My ms office is activated now. LIKED AND SUBSCRIBED

[bricenomiguel]

Great training! How about also editing the linked table and adding new records on the user form?

[paulolabordo]

Hi Randy
Great Video.

Just a question
Can we do the same thing u did on the on the previous video on a 1 click view where the textbox resizes automatically ?

[FrederikLawson]

Hi Randy
Great video...
Just few comments :
1. Maybe the header should be more than 2 row.
Where there are some buttons like ADD (new record), SEARCH (instead of scroll up or down the sheet)
2. Also a button for changing or deleting the PICTURE

Questions :
1. How about if the data in the linked tables (Invoice or Invoice Items) is more the box size ?
Will it be a scroll up/down beside the box ?
2. How to create the database on different files ?

Thank you and regards

[martin]

I would like to see a hotel reservation system. Keeping customer bookings - which type of room (sea-view, standard etc.) which room number, when arriving when departing, flight number. Category of guest eg. regular or infrequent. Customer contact details as a separate sheet to keep for future bookings and repeat stays. Extra requests eg extra blankets, kettle, hangers.

[js]

I hope to request this year there a program for Document Controller use like master register, logs, transmittal etc.

[francoismarsau]

Briliant video as would I go about instead of start and end row to only show columns 3, 5, 6, 7 and 13 for instance?
One again thanks Randy

[boodahbellie]

Question, is it possible in excel to make a cells contents span 2 cells vertically? Similar to 'Format Cells>Alignment>Center Across Selection'. For instance, G9:I9 has the word 'HOURS' centered across the 3 cells and underneath that, G10:I10 has a value in each cell individually. I want the cell contents to the right and left of G:I to be centered between rows 9 & 10.

[tomcummins]

Hi Randy - fantastic resource - thank you. is it possible to have the code simply just look at a Power Query single output sheet with the same popup? I have several merged
PQ resulting in an output with 30K lines so a form would make it really easy for the end user to interrogate - Regards Tom C.

[karimmimoun]

I have a question hopefully you can help me with this I have a user form that automatically creates and ID nr when this cell is processed in my sheet pending my cell is automatically moved along with the ID nr to the finished sheet . The problem is since my ID has been moved when I create a new data in my pending sheet I get back the same ID nr . How can I link these together so I don't have double ID nr when I create a new data with the user form ?
Thank you for your video is very helpful 😊