Скачать или смотреть 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.

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
00:00 Introduction
02:22 Creating a new UserForm from scratch
04:42 Adding labels, text boxes, option buttons and combobox
10:05 Adding command buttons and formatting the form
13:42 Setting up the worksheet for data entry
16:58 Adding code for data entry functionality
24:07 Implementing form validation for name entry
29:14 Adding validation for department selection
34:15 Adding validation for date entry
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial