Free Excel VBA Course #25 - User Form Deep Dive in Excel VBA (Advanced)

In this video, I will show you some advanced things you can use with a Userform in Excel VBA.

I will show you how to create a functional data entry form that is also configured to show error in case the desired entry is not made.

For example, if a field expects a number and you enter text, it will get highlighted in red.

#Excel #ExcelTips #ExcelTutorial

[maheshdeshpande]

Hii, Thank you for smooth explanation. The thing is I literraly practised withou audio and learned. It was great experience...😀

[mushayawagunha]

Baba, this is good. Hats off and thank you

[ashfaquewkhan]

Excellent video -- for first row addition 😇i had managed to do it.

[osoriomatucurane]

Awesome tutorial on userform data validation.

[silvestrecamposano]

Thank you very much. Your topic is very comprehensive, very

[codalisa]

Excellent video with a professional explanation.

[hlahlakhonziwe]

OMG What a good lecture after I've been struggling with this, It's just flowing, Excellent Video.

[naatslibrary]

It was really a deep dive... Excellent Sumit... I really found it useful as it cleared all concepts

[azaddeenazom]

thank you sir for the excellent explanation. I have a query how can we put the calendar in the place of the date of joining ?

[excelemployeeleavetracker]

Very Interesting VBA coding....I Like It. I will try it out today to see if it is something I could use. Keep Up The Great Work My Friend!!

[MrEJ]

Thanks 4 detail explanation.
I too have similar doubt as Aayush Bajaj did

[deepukp]

Great Video!! Thank you so much for Wonderful content. Requesting you to Run this code with empty data in Second row because it is throwing an error for me 1001

[turnswood]

Excellent video. I found a condition that lets invalid data into the database. It has to do with the Department field. You would only want valid departments that are in the list to be entered, however, the combo box lets you type anything into the field and accepts it. How would you prevent that from happening? Is there a validate lookup? property that prevents data entry, etc. Thanks. Irv in Florida

[novaordemdesantiago]

Trump Excel, show us the real US Election numbers!

[SeanBaker-hurq]

Can i Check if record exist and populate the form fields automatically, lets say i use a ID Number or Product Number for fist field

[vaibhavjain]

How to put date picker in this
And disable the text to be written on department text box ?

[srkim]

Please use TAB key when you coding, Easy understand for user

[vijaysahal]

nice userdeep coading but serial number should start 1 nd add data should also start by userform frm 1

[rishikeshshiradkar]

Sir please provide Update and Delete button code in userform of vba

[aayushbajaj]

How to ensure that the combo box contains values only from drop-down list because if user enters value other than the drop-down list it also gets accepted .
Thanks