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

Рет қаралды 21,831

4 жыл бұрын

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.
✅ Download File: bit.ly/vbacourse-25
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 42

@maheshdeshpande7602 2 ай бұрын

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

@osoriomatucurane9511 2 ай бұрын

Awesome tutorial on userform data validation.

@naatslibrary7822 3 жыл бұрын

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

@mushayawagunha Жыл бұрын

Baba, this is good. Hats off and thank you

@hlahlakhonziwe2240 Жыл бұрын

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

@codalisa007 2 жыл бұрын

Excellent video with a professional explanation.

@silvestrecamposano6317 Жыл бұрын

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

@MrEJ 4 жыл бұрын

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

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much. Excellent video.

@excelemployeeleavetracker1274 3 жыл бұрын

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

@azaddeenazom1464 3 жыл бұрын

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 ?

@JATINKUMAR-qu4vi 2 жыл бұрын

Great video 👍👏👏👏

@amaythakkudu3839 3 жыл бұрын

Man...you are a Gem.!!!

@JATINKUMAR-qu4vi 2 жыл бұрын

Very useful video

@turnswood 3 жыл бұрын

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

@mishraamukesh 3 жыл бұрын

Innovative one...

@dianat.sandoval2561 3 жыл бұрын

thanks!!

@rakeshthakur9403 Жыл бұрын

Nice video

@knight7466 Жыл бұрын

Thx 🙏

@deepukp860 Жыл бұрын

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

@ahmedsaad7870 4 жыл бұрын

thanks for the video i need a data validation to check all text box are numbers in one code i imagine that i will write for each txt_" " if isnumber then "do whatever" else exit sub end if could you help please as i have over than 50 text box in my user form

@manishkumarchd 3 жыл бұрын

super

@vaibhavjain6619 5 ай бұрын

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

@bijishvijayan3690 4 жыл бұрын

Say if I have to add another text box for entering a time of an event, then is it possible to inform the user (with a popup or something) what format of date has to be entered in the textbox?

@amaythakkudu3839 3 жыл бұрын

I will try to help .explain pls

@SeanBaker-hu4rq Жыл бұрын

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

@shatrujeet 2 жыл бұрын

How can we display a cell value in a form? Like if I have a form for filing a registration form and I want to display Registration No. at the top.

@novaordemdesantiago1890 3 жыл бұрын

Trump Excel, show us the real US Election numbers!

@srkim9085 3 жыл бұрын

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

@mattLeeze 4 жыл бұрын

How can you delete the contents of the form after user clicks on the "Add Details" commandButton (I'm trying to move the data onto a separate sheet (hopefully!) that the user cannot see (will make a pivot for them)? If the user clicks on it, then steps away for a while, they might not remember if they submitted it. Then the sheet can have multiple duplicates.

@mattLeeze 4 жыл бұрын

update: I typed: Unload Me

@aayushbajaj8456 4 жыл бұрын

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

@nlevasseur88 4 жыл бұрын

Set the Style property of the ComboBox to "fmStyleDropDownList"

@umamaheshk6151 3 жыл бұрын

Sir, as we checked date @39:57. how can we check integer and string as well. Because When I add a number in Name, it accepts, But it shouldn't not accept na so how can i check integer and string? and one more sir, if we have not filled first row then it shows Run time error '1004': Application-defined or object-defined error if we filled first row then it goes fine.... what should we do sir?

@rishikeshshiradkar8201 Жыл бұрын

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

@vijaysahal4556 4 жыл бұрын

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

@mohammedshafi3637 Жыл бұрын

If i enter numaric in name text box it allowing how to restrict it

@harshaltaswala671 4 жыл бұрын

I need to understand that how to get the start value in "Sr no" as 1 when there is no data entered in the table.Here in the example you have given you have firstly entered the first line item manually then have prepared the vba coding. I need to understand that what change i need to make in above code to accept the value without entering anything manually in the table.Thanks in advance

@phongnguyenthanh9076 4 жыл бұрын

the row's value that entering always = row's value above + 1.

@IvanMiletic 3 жыл бұрын

The simplest way to do it would be something like this: If Range("a2").Value = "" Then Range("a2").Value = 1 Else Range("a9999").End(xlUp).Offset(1, 0).Value = Range("a9999").End(xlUp).Value + 1 End If Notice also that I used xlup here. In my experience xldown is worse since it doesn't work if you only have 1 entry, while xlup does. In this case xldown worked since he included a1 in the range, but it wouldn't work, had he started from a2 (where numbers start) or if he had no headers.

@vijaysahal4556 4 жыл бұрын

serial 1 manual and add data 1 manual