Very good. One suggestion though. Instead of using the SEARCH button to display information below, remove the SEARCH button and trigger the information with a CHANGE event on the combobox. For example when you change from Item 1 to 2 the form below will populate automatically.

Excellent Explanation. God Bless you Sir!. Hats Off

Thx Sir All your Videos Are Good And Useful I Have Downloaded a lot Of The Thankyou Very Much Sir

Useful video. Thanks.

Honestly.... I should appreciate your efforts. Thanks so much, very impressed tutorial God bless you. I have saved more than 75 videos but this is amazing so I followed as your staps but I got wrong in a place of combobox started the VBA message... member all ready exits an object module from which this object module derives, other one how could enter close and cancel button please let me know as soon as possible I couldn't complete the application please please I beg you Thanks

Dear Mr Dinesh, I have added a new frame with additional information , everything is running smooth. Now i would like to add an other button to delete only the information in the new frame named frame 4 without deleting the information in the frame 2. Now i have a database with a total of 10 columns so 5 column are dedicated for the frame 2 same as your example and 5 other for the frame4 that i have added. if i use your delete button the entire line with the 10 columns are deleted. but i want only to delete the last 5 column per employe name selected. How to do?

Sir, thank you for the video. I get this Error 438 Object doesn't support this property or method. But when i delete the call comboboxFill it doesn't give this error but the combobox also miss-behaves. have you come across this issue with any other students. Any solutions for this?

thank you!!

Do you have lesson so that if I forgot to press save it will alarm me when I enter new data in the entry sheet?

omg lesson namin yan!!

Hello Mr. Dinesh! I really appreciate your presentations and especially this one. However a difficulty remains for me. And that forces me to ask you this question: How do you make sure that the numbers transferred from TextBoxes to Excel cells do not take the "Text" format, but are always in "Number" format. This is a serious concern for me. Thanks for your special help for me. Joseph

I need your help dinesh regarding one of your videos.

Sir If Row 1 is merged For Heading And row 2 As Well And in Row 3 You have Different Headings For Data Entry Such As Sr No , Item Name ,Description Etc Then The to save using offset as in this Video is not working Properly It doest not Find The Proper Current Row Below THe Row 3 Where Data Is to Be Filled But If Row 1 And Row To Is unmerged Then the data is filled in The Current Row Properly

Is there a way to modify the Save button, so that if the entry already exists it updates the information instead of adding a new with the same item no.?

Sir, I am in the school so can you tell me, how to print marksheet from a prepared sheet sepetetly for every students by creating a form

I was interested in grabbing the codes from a file...

thank you for this nice demonstration. please can you share with me your file to better understand how the Macro operation

Help full video sir

thank you sir.

Dear Sir, I want to open a Sql database in excel using vba and managing the records(adding,updating & deleting) using excel spreadsheet, as the user is more familiar to use excel for updating the records. As a developer I want to use that database (SQL) to prepare crystal reports, Pivot table etc. Kindly refer any posting or a new posting.

hello sir thank you for all your videos , it's helped my work a lots , i but just can't figure out the update button my data have imei numbers some time it duplicate in excel i run the search button found the first result and last result ....but when i run update button it's only update the result that found first can you help me to search and update data on ether first result or last result please thank you

Good video. I was going to see where the file was located on your website however the website doesnt appear to be online at the moment. It responds with a "warning" message and text after it (can not copy it here for some reason).

Hi .. I just wanted to ask if what is the code of save or send commandbutton on my School Form database.. I need it please help me . I need codes for my save or add button.. please send it to me .. help please? Help please?

the coding is in sheet1home or sheet2 data?

Hello Sir, I am trying to make a userform for Data Entry, and I required Search Button, but mention code is not working, can you help me for the code of Search Command Button.

Hey i want to save products name and data in excel so that if i write products name the product price automatically come in price column

Hello... How you created the form and created the code

Not sure if this question belongs here... But... An employee can have multiple phone nos. 😵 Task : How to capture it in userform (remember number of phone numbers are unknown) 😒. Next how to design excel sheet /table, which can store that phone information (again we are unaware of the number of phone numbers)

uploading pdf file with record is very essential these days

hi dinesh

Hello Sir Thanks for this Video, This helped me a lot. I have made a user form Database same like what u have done in this video. But instead of Item NO. i have Company name with Addresses and i have multiple address for same company name.So when i search company name with diffrent addresses the combo box reverts only to the earliest address. What i want is to search for next address with same company name when i click SEARCH 2nd time and so on. Kindly assist me with the same. Thanks in Advance Please check this link with Screenshots. stackoverflow.com/questions/38078823/why-does-the-combo-box-revert-to-the-earliest-record-only

wag nyo pong buburahin or idedeleted ok!!

thank you!!