Thank You! Thank You! Faced with an unimaginable deadline, and at least 5 years since I last looked at VBA, I was able to follow your entire tutorial and re-produce the whole project and modify it to fit our needs. You made me look like a rock star! Thank you!!
time table : @3:42 create the data result sheet in the output excel file @6:32 creating the form @16:38 putting option in the drop down list @18:37 programing the save button " coding the collection of text boxes input and export the data to excel output sheet and the table viewer in the form " @22:50 the code for the programing the excel output sheet name and the error message box to warn the user there is a fault in the input @24:05 adding the data to excel output sheet @28:21 emptying the text boxes after the input is done @32:29 programing the refresh data " the list box that show what data we put in the excel output sheet " @37:37 programing the reset button @38:07 programing the exit button @40:12 programing the search button @46:34 programing the update button @49:55 programming the delete entry button @52:21 programing the list box to show the output @55:55 programing the button to show the form
First, thanks for the lesson, it helped me a lot. Second, just a small thing, when you set the variable "lr" (Last Row), you writed "le", it work at the same.
Awesome tutorial, crystal clear. You are truly a legend on the subject! With the delete control, the code is a bit longer, why not using the clear method as Me.Clear?? Just thinking louder! Before clearing it would be great to get a confirmation (MsgBox "Are sure you want to clear the record?", vbYesNo), If yes then proceed. At the end, as you run the macro to show the form and it overlaps with the data sheet, again, it would be great to get the data sheet hidden.
Great Tutoring. With the delete function, once the delete has been executed its done. Just wondering if a a message can be created to ask if you are sire you want to delete with a Yes or No BEFORE its deleted ??
Hi, I must say it's very impressive video it helped a lot to create. I have issue after creating everything I shared the excel with multiple people and at a time entry from many people will failing my excel entry data sheet. Please provide any solution for this
Thank you for your very clear and helpful tutorial. You have taken my project to the next level :) Currently the list box displays all data entries at all times, which is ok as a general display for users to scroll through, but on searching for a record using ID number I would like the list box to only display the rows and columns of data that match the ID in the search box. Most of the time an ID will be unique to 1 row of data but occasionally there will be 2 or 3, so this would also function as a way for users to find, edit and/or delete the correct record by double clicking on the entry in the list box. Please would it be possible to confirm what I would need to add to the code to only display matched search criteria in the list box? Many thanks for your kind help, Cat
Thank you so much! this is amazing! I have a small question, how can you prevent duplications? for example if you want to make sure that all employee IDs are unique, and in case you have entered a duplicated number, a message box appears telling you that and the rest of text boxes are cleared. Please help.
Thank you for all the tutorials. They are educative. I wish you please help me: I have created a database in excel. And i have also created the userform. The database that i created has sections all in one worksheet. The sections are: (1). staff information, (2). Students information and (3). Parents information. I used the combo box to list the three sections. So, i want to write a vba code to save staff information in the staff section if i select staff, and save students information under the student section if i select students. I wrote this code below, but it's not working properly. Dim sh as worksheets Set sh=Thisworkbook.sheets("sheet name") Dim lr as long lr= sh.cells(rows.count,2).end(xlup). offset (1,0).row for x=5 to 11 Because we only need 7 staff and the empty row starts from 5 to 11. And then i said: If sh.cells(x,2).value=staff then sh.cells(x,2).value=txtname.value So on... For students: For x= 14 to 100 If sh.cells(x,2).value=students then sh.cells(x,2).value=txtname.value And so on When i use this code even though it saves the information under the required section, but the information will occupy the entire section. Please help me out sir. All of what i did here, i learned most from your tutorials. I always download your tutorial.
Sir, could you please create a video for creating a large and separate VBA form at once? This training provides a large data entry format, but after running it, the full format doesn't show due to the inability to expand the zoom. Could you demonstrate how to zoom in and out to fill the black space?
tqvm...this is very helpful...i have tried and it is working....just one thing, the search function only works when I entered the Emp.ID....other than that, the search function will not work...am I right?let say if I want to search by name...anyway..this video is great
nice information and it helped alot. Thank You. When i double click in the listbox the info appears above except the date is a jumbled set if numbers and does not stay in format. How do I fix that?
This is great job, thank you very much for the good work. I created my form and is working perfectly, please help me on how to add "Do you want to delete the data" vbYesNo before deleting. I watched many of your videos and I tried the code but it's not working. please help.
Quick questions of adding filters: 1) if someone wants to arrange the excel sheet based on dates or any filter. How to code it ? 2) if we want to add filters in list box for visual how to do that..
Thanks for your excellent explanation.... Can you help me..specific date wise data entry. If i select 12-08-2023 date but today date is 18-09-2023.. In that time the data will save this specific day. (12-08-2023).
Tried the code....it's simple and working... It requires modification for warning alert or duplicate data entry.... If you hit save ...it enters infinite entry to the database. Also, search function in the list box not working...
Watch this video to learn more and I have mention about duplicate ua-cam.com/video/0ogv43DSzdo/v-deo.html For search data by multiple ways ua-cam.com/video/CH9rtus7HLY/v-deo.html&ab_channel=Er.PediaEr.Pedia
My only question is why use a ListBox showing the records instead of just using the form to insert records into the worksheet? Is there something I am missing? Thank you.
Thank you for your efforts .. I faced a problem with saving data into a new row .. Once I save data, it will go to replace the previous one and so on .. How to solve it?
sir, In the beginning, you did not state how you created the"MACRO" button to open up the data information form. It also would have been nice if I click to open this project it opens automatically the input form. is it possible to write a short script for the save option?
When i convert the range to table, and delete a record with reference no. 1 and add the same record again then it doesnt show in the excel sheet and also it doesnt show in the listbox, but when i apply any advance filter then same data shows up, how to fix it? the data must be shown without applying advance filter every time.
i have a Problem if i press on Save it will save in ecxcel but on the first raw, then wenn i but new data in vba and press on Save it will delet the old won and replaced it with the new won? it will notput automatikli in the new raw now it just replaced the old with the new won. What can i do to chnage this?
Love your tutorials. Made me a workbook with films and series I have seen. But... When I search for a film/series I need to be exact in searchbar. I need to set uppercase and lowercase depending where I put it in the title. I want to do the search with just lowercase. Is it possible to do that?
Can you add an entry field, so after each new line is entered it counts up. This makes searching for information easier if there are similar dates with different information.
Hello. what is the code if i want to search not just in the employee ID? Like for example i didn't knoe the Employee ID but i know the name. Please help thank you
Sir, Many thanks for uploading such a video. Sir, I am facing problem in the statement as lr=Sheets("Worksheet").Range("A"&Rows.Count).End(x1Up).Row and also I couldn't not catch you how you have brought Regresh() in the code. Please help me by let me know the exact procedure to solve the matter. Thanks once again.
This was an excellent tutorial. I was able to create my user form without any issues. Thank you very much! However, what if someone saves the Employee ID twice? You now have multiple lines with different information. How can you prevent this from happening?
Sir. It was a well presented video. Thank you. Would u pls advise when I update my data, all check box information was changed from 1 to TRUE. But I want the result is shown in "1" instead of "TRUE". Thanks.
hi I tried your tutorial and everything works except the update part that is wrong, yet I wrote it identical the values do not update, could you have a solution?
Hi Er.Pedia, may you can help on this how can coding for the duplicate value 1 record is already done but when i'm click on the Edit and after edit i will save again then it will capture duplicate value ? can you advice on this ?
Good day! Upon Checking for the Search cmdbttn, using the same format, only the the ID can be use in searching bttn, other than ID like name and gender cannot be use for searching bttn. How to properly search using other detalis like gender, emaill add an so on? thank you in advance
In this line If Sheets("Worksheet").Cells(Y, 1).Value = txtsearch.Text Then after the Y, 1 change the value corresponding to the column ie Y, 2. One other trick is right up the top of your coding sheet, type option compare text This disables case sensitivity when searching.
We're sorry. You can't access this item because it is in violation of our Terms of Service. Find out more about this topic at the Google Drive Help Centre.
A very informative video. Thanks for this sir. Will you please make a form for sales invoice which is very imported and the fact is that even I am not able to find it in UA-cam for almost 7 months. If you could please make a video for sales Invoice form it will be so kind of you. Thanks
Very good Tutorial.. just what I need.. BUT, I'd liek the form to update a TABLE, rather than a simple Data array. what changes do I need to do to the Code Simon
Thank You! Thank You! Faced with an unimaginable deadline, and at least 5 years since I last looked at VBA, I was able to follow your entire tutorial and re-produce the whole project and modify it to fit our needs. You made me look like a rock star! Thank you!!
time table :
@3:42 create the data result sheet in the output excel file
@6:32 creating the form
@16:38 putting option in the drop down list
@18:37 programing the save button
" coding the collection of text boxes input and export the data to excel output sheet and the table viewer in the form "
@22:50 the code for the programing the excel output sheet name and the error message box to warn the user there is a fault in the input
@24:05 adding the data to excel output sheet
@28:21 emptying the text boxes after the input is done
@32:29 programing the refresh data " the list box that show what data we put in the excel output sheet "
@37:37 programing the reset button
@38:07 programing the exit button
@40:12 programing the search button
@46:34 programing the update button
@49:55 programming the delete entry button
@52:21 programing the list box to show the output
@55:55 programing the button to show the form
file not found
I wants to express my profound appreciation to this super tutorial. Thank you Sir!
A big thank you from bottom of my heart. Learned and enjoyed the video. Sir.
you are legend brother. easy and straight to the point.
You are indeed a great teacher, the approach used to explain every bit of the video is superb thanks
its a very good form to understand the beviour of VB. Time for understanding it, is vital. Thanks
Well done. It helped me to create my data entry form. Thanks
First, thanks for the lesson, it helped me a lot.
Second, just a small thing, when you set the variable "lr" (Last Row), you writed "le", it work at the same.
Thank you for this video. Well explained and it gave me a lot of ideas. You did a great job.
Thanks so much. i feel like a pro now
Thank you indeed for you generosity and patience in sharing this valuable knowledge, Sir. - From Burma
Awesome tutorial, crystal clear. You are truly a legend on the subject! With the delete control, the code is a bit longer, why not using the clear method as Me.Clear?? Just thinking louder! Before clearing it would be great to get a confirmation (MsgBox "Are sure you want to clear the record?", vbYesNo), If yes then proceed. At the end, as you run the macro to show the form and it overlaps with the data sheet, again, it would be great to get the data sheet hidden.
Excellent video and training style, easy to understand
Great Tutoring. With the delete function, once the delete has been executed its done. Just wondering if a a message can be created to ask if you are sire you want to delete with a Yes or No BEFORE its deleted ??
wow nice tutorials , can send another link to download the script thank verymuch high appreciated
Hi, I must say it's very impressive video it helped a lot to create. I have issue after creating everything I shared the excel with multiple people and at a time entry from many people will failing my excel entry data sheet. Please provide any solution for this
Thank you for your very clear and helpful tutorial. You have taken my project to the next level :)
Currently the list box displays all data entries at all times, which is ok as a general display for users to scroll through, but on searching for a record using ID number I would like the list box to only display the rows and columns of data that match the ID in the search box.
Most of the time an ID will be unique to 1 row of data but occasionally there will be 2 or 3, so this would also function as a way for users to find, edit and/or delete the correct record by double clicking on the entry in the list box.
Please would it be possible to confirm what I would need to add to the code to only display matched search criteria in the list box?
Many thanks for your kind help,
Cat
Thank you so much! this is amazing!
I have a small question, how can you prevent duplications? for example if you want to make sure that all employee IDs are unique, and in case you have entered a duplicated number, a message box appears telling you that and the rest of text boxes are cleared.
Please help.
Excellent work, Sir. Thanks from Sri Lanka.
Wow! Great Video
thank you so much. this video helped me a lot.
Thank you for all the tutorials. They are educative.
I wish you please help me:
I have created a database in excel. And i have also created the userform.
The database that i created has sections all in one worksheet. The sections are: (1). staff information, (2). Students information and (3). Parents information.
I used the combo box to list the three sections.
So, i want to write a vba code to save staff information in the staff section if i select staff, and save students information under the student section if i select students.
I wrote this code below, but it's not working properly.
Dim sh as worksheets
Set sh=Thisworkbook.sheets("sheet name")
Dim lr as long
lr= sh.cells(rows.count,2).end(xlup). offset (1,0).row
for x=5 to 11
Because we only need 7 staff and the empty row starts from 5 to 11.
And then i said:
If sh.cells(x,2).value=staff then
sh.cells(x,2).value=txtname.value
So on...
For students:
For x= 14 to 100
If sh.cells(x,2).value=students then
sh.cells(x,2).value=txtname.value
And so on
When i use this code even though it saves the information under the required section, but the information will occupy the entire section.
Please help me out sir.
All of what i did here, i learned most from your tutorials. I always download your tutorial.
Sir, could you please create a video for creating a large and separate VBA form at once? This training provides a large data entry format, but after running it, the full format doesn't show due to the inability to expand the zoom. Could you demonstrate how to zoom in and out to fill the black space?
tqvm...this is very helpful...i have tried and it is working....just one thing, the search function only works when I entered the Emp.ID....other than that, the search function will not work...am I right?let say if I want to search by name...anyway..this video is great
This was an excellent tutorial.
Appreciate😉
Thank you very much for the lesson, it's a pity that the example file is no longer available.
Thanks for the great video. How do you trap duplicate employee ID when adding new user ?
Thankyou so much for brilliant userform. But pls let me know how do I search data from multiple sheets. Regards
It's very useful to me thank you so much
Informative.
I am not able to download the file. I get error stating privacy & Term violation. Can you please help. This is really an awesome video.
Excellent, Thank you so much.
Thank you for this. I would like to know how to add filter for the listbox.
Awsome video….how to send search data through outlook kindly advise
nice information and it helped alot. Thank You.
When i double click in the listbox the info appears above except the date is a jumbled set if numbers and does not stay in format. How do I fix that?
This is great job, thank you very much for the good work. I created my form and is working perfectly, please help me on how to add "Do you want to delete the data" vbYesNo before deleting. I watched many of your videos and I tried the code but it's not working. please help.
Great job, but how we can filter listbox as we type in a search box, pls if you can help me in the same user form in this video , thank you in advance
Quick questions of adding filters:
1) if someone wants to arrange the excel sheet based on dates or any filter. How to code it ?
2) if we want to add filters in list box for visual how to do that..
thank you mi pana!!! for posting
Thanks for your excellent explanation.... Can you help me..specific date wise data entry. If i select 12-08-2023 date but today date is 18-09-2023.. In that time the data will save this specific day. (12-08-2023).
nice tutorials
Hello Sir
Thank you for the nice explanation and nice video.
Please tell the code how to avoid duplicate entry of Employee ID.
Kind regards
Venu
Thank you very much for your video, but if you want to add more testboxes to the Userform, is there a way?
Would love to access the file but the link does not provide a location to download to the file.
Tried the code....it's simple and working...
It requires modification for warning alert or duplicate data entry....
If you hit save ...it enters infinite entry to the database.
Also, search function in the list box not working...
Watch this video to learn more and I have mention about duplicate
ua-cam.com/video/0ogv43DSzdo/v-deo.html
For search data by multiple ways
ua-cam.com/video/CH9rtus7HLY/v-deo.html&ab_channel=Er.PediaEr.Pedia
thank u for this; possible to reupload the file? it isn't there
Love u lot sir❤❤❤❤❤
Thank you for Your Help
Nice dude and thanks
Teşekkürler Türkiye den Selamlar
My only question is why use a ListBox showing the records instead of just using the form to insert records into the worksheet? Is there something I am missing? Thank you.
Excellent, thank you
Thank you for your efforts ..
I faced a problem with saving data into a new row ..
Once I save data, it will go to replace the previous one and so on ..
How to solve it?
sir, In the beginning, you did not state how you created the"MACRO" button to open up the data information form. It also would have been nice if I click to open this project it opens automatically the input form. is it possible to write a short script for the save option?
very nice tutorial.Thank you
The best.
All in one
very good toturial.. can i get copy
When i convert the range to table, and delete a record with reference no. 1 and add the same record again then it doesnt show in the excel sheet and also it doesnt show in the listbox, but when i apply any advance filter then same data shows up, how to fix it? the data must be shown without applying advance filter every time.
Please can you include image upload?
i have a Problem if i press on Save it will save in ecxcel but on the first raw, then wenn i but new data in vba and press on Save it will delet the old won and replaced it with the new won? it will notput automatikli in the new raw now it just replaced the old with the new won. What can i do to chnage this?
Love your tutorials.
Made me a workbook with films and series I have seen. But...
When I search for a film/series I need to be exact in searchbar. I need to set uppercase and lowercase depending where I put it in the title.
I want to do the search with just lowercase. Is it possible to do that?
Thank you very much for your video
Can you add an entry field, so after each new line is entered it counts up. This makes searching for information easier if there are similar dates with different information.
yes, we can easily add that too. I will soon make the video
@@sagar.banjade.5 it would also be helpful to have a filter as you text option on the search field or dependent combobox
Hello. what is the code if i want to search not just in the employee ID? Like for example i didn't knoe the Employee ID but i know the name. Please help thank you
I would like a video on using Date field in the VBA form?
Hello sir plz tell me how to set color in male or female word in combobox and list box
Thank you sir 💯
thank you very much sir
how do I change the coding for the search function to search data from any field?
Great job
Sir, Many thanks for uploading such a video. Sir, I am facing problem in the statement as lr=Sheets("Worksheet").Range("A"&Rows.Count).End(x1Up).Row
and also I couldn't not catch you how you have brought Regresh() in the code.
Please help me by let me know the exact procedure to solve the matter. Thanks once again.
I'm also encountering an error on this part. How did you resolved it?
@@louiejayparas5349 just put (xlUp)...previously I typed "1" instead of "l" (small letter 'l'). Thanks.
instead of lr put le. cause you declared le not lr.
This was an excellent tutorial. I was able to create my user form without any issues. Thank you very much! However, what if someone saves the Employee ID twice? You now have multiple lines with different information. How can you prevent this from happening?
We can avoid saving duplicate by applying validation. I have mention about duplicate in this video
ua-cam.com/video/0ogv43DSzdo/v-deo.html
@@sagar.banjade.5 Thank you!
Thanks for teaching. Can you teach how to create none duplicate ID in this form ?
Watch this video I have mention about duplicate
ua-cam.com/video/0ogv43DSzdo/v-deo.html
Great and Easy
Wao many thanks did you sharing the download please, the link its break
Sir. It was a well presented video. Thank you. Would u pls advise when I update my data, all check box information was changed from 1 to TRUE. But I want the result is shown in "1" instead of "TRUE". Thanks.
I can teach you this i am expect on this
Sir, I tried your form and made an error somewhere, I can only see the Userform in draft mode?????? how do I fix this? would you be able to assist
hi I tried your tutorial and everything works except the update part that is wrong, yet I wrote it identical the values do not update, could you have a solution?
Hi Er.Pedia,
may you can help on this how can coding for the duplicate value 1 record is already done but when i'm click on the Edit and after edit i will save again then it will capture duplicate value ? can you advice on this ?
How to get the data entry form software.
Your tutorial is nice, but I am unable to get Cells option in command With sh and next row .Cells. Please guide me
Hi Pedia,
1, Could you please update the download link? Its now unaccessible.
2, The code should be "Dim lr As Long", right?
excellent
I want a code like this but to color the row that has a condition with a nother color when update data in update command button
Is there anyway to download the code settings pls???
Good day! Upon Checking for the Search cmdbttn, using the same format, only the the ID can be use in searching bttn, other than ID like name and gender cannot be use for searching bttn. How to properly search using other detalis like gender, emaill add an so on? thank you in advance
In this line If Sheets("Worksheet").Cells(Y, 1).Value = txtsearch.Text Then after the Y, 1 change the value corresponding to the column ie Y, 2. One other trick is right up the top of your coding sheet, type option compare text This disables case sensitivity when searching.
Great work 👍🌹
Thank you
@@sagar.banjade.5 plz send me the practice file to my below email :
Tawfeeq_alsrori@yahoo.com
Plz send me the practice file
@@tawfeeqalsrori9092 Do check yr mail
plz send me the file suraj57sam@gmail.com
We're sorry. You can't access this item because it is in violation of our Terms of Service.
Find out more about this topic at the Google Drive Help Centre.
how to give condition in save button like " do you want to save the data?" then hwo to coding of this?????
Nice
How do I contact you privately for assistance?
How did you get sub refresh data?
Sir, how to protect the data for the worksheet to avoid delete data my mistake
A very informative video. Thanks for this sir.
Will you please make a form for sales invoice which is very imported and the fact is that even I am not able to find it in UA-cam for almost 7 months.
If you could please make a video for sales Invoice form it will be so kind of you.
Thanks
Thanks for the positive review. I will try to make that video.
Very good Tutorial.. just what I need.. BUT, I'd liek the form to update a TABLE, rather than a simple Data array. what changes do I need to do to the Code
Simon
For that we need to make the table dynamic
Thanks a lot could you please share file
Hi sir mera ek questions he jo male or female word hai uska color kaise change kare plz bata na dono ko different colours set karna hai
Combobox me bhi or list box me bhi Change kara hai
Thank you so much
Awesome video. Anyway I could get a practice sheet?
For that I need yr gmail id