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
The download file link not working because "Unfortunately, you cannot access this item because it violates our Terms of Service." Well, so what? You offers your workbook, but does not give it.
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.
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.
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?
Bro i have problem in the delete button. I did just like what you did. But there debugger at Rows(y).Delete.. I dont know how to proceed. I stuck here.. it says run time error '1004' Delete method of range class failed Still No reply after 9 months.. 😢
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?
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).
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! 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!!
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..
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.
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?
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.
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 ??
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
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.
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.
I accidentally created a virus from your data!! It will automatically run 500k data because i didnt correctly put the validation and use update button.
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.
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
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.
Dear Sir, Trying to run your "Employee Details Dynamic form" which looks great, however an error showed up. It said: "Error 2147352571 (80020005) Cannot set up the characteristic (reference) ColumnWidths. Type doesn't match" Looking in the code where the Error showed up, this line came up highlighted: .ColumnWidths = "80,140,70,130,100,150,80,80" Hope the can tell why and what to do. Thank you in advance
Welcome Thank you very much Excellent and clear explanation I have a question I hope you can help me. I have a problem that I could not solve. The problem is as follows (duplicate data): I have created a database in VBA. And I worked in it a button to search, a button to save, a button to query, a button to edit, a button to open a file, and a button to exit. The problem is that the data gets duplicated from the edit button. As for the data save button, I used code to not duplicate the data and it worked and no longer accepts any duplicates. The recurrence occurs from the modification button when I query the data of an employee who already exists (i.e. whose data has been previously entered), and I modify his data with the same data of another employee who is also present in the same database. It saves the modification and migrates the data to the sheet or database, the data duplication occurs and this is the problem I'm having. I used the no-repeat code I used for the save button But it didn't work properly Please help me
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?
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?
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.
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
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.
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 ?
when i try to save the data, it closes the userform..... if i remove call refresh data, then it works ok, but it doesnt show list box at start of userform....However, update button works efficiently it does not close userform nor it closes listbox
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
Would love to access the file but the link does not provide a location to download to the file.
wow nice tutorials , can send another link to download the script thank verymuch high appreciated
excel userform design account statement extrait ?????
And excel userform design account statement extrait and download form excel extrait
the download file link not working
The download file link not working because "Unfortunately, you cannot access this item because it violates our Terms of Service." Well, so what? You offers your workbook, but does not give it.
The Download file link: fails. Can you fix it? I would love to see the finished product. Thanks!
Please Help me, I can Open the file, because it says "We're sorry. You can't access this item because it is in violation of our Terms of Service."
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.
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.
While I open Visual Basic there is no Properties userForm Box! why??
Sir, how to protect the data for the worksheet to avoid delete data my mistake
The link don't work
How can I add a calendar to this vba form, I have tried and cant seem to find a way.
Bro can you give me code of pervious and next commoned button
I want to scroll my list box with mouse,
what to do?
Im stuck on the list box. Even i call it it doesnt work
how we can put un bottom to send the data to email ?
What if there is no match data in search box?
A big thank you from bottom of my heart. Learned and enjoyed the video. Sir.
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?
Bro i have problem in the delete button. I did just like what you did. But there debugger at Rows(y).Delete.. I dont know how to proceed. I stuck here..
it says run time error '1004'
Delete method of range class failed
Still No reply after 9 months.. 😢
th-cam.com/video/uTtRWKFcy5w/w-d-xo.html
ক্সেল শিখুন: Microsoft Excel যোগ, বিয়োগ, গুন, ভাগ সুত্র। tutorial for beginners
Popcom 🎉❤❤❤❤❤❤❤❤🎉😊❤😊😊😊🎉😂😂😂🎉
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?
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).
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 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
can i please get the file. Thank you very much
For this I need yr gmail ID
Thank you very much for the lesson, it's a pity that the example file is no longer available.
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!!
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..
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.
Thanks for the great video. How do you trap duplicate employee ID when adding new user ?
Can you pls share the macros file?Google drive link doesn't work
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?
Thank you for this video. Well explained and it gave me a lot of ideas. You did a great job.
l need source code of it
We're sorry. You can't access this item because it is in violation of our Terms of Service. File unable to download please help me
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.
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 ??
Excellent, Thank you so much.
Useless
how to give condition in save button like " do you want to save the data?" then hwo to coding of this?????
Thank you for this. I would like to know how to add filter for the listbox.
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
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.
im having issues on the UPDATE button, its as if its moving 1 cell to the next row.
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.
Wao many thanks did you sharing the download please, the link its break
Thank you indeed for you generosity and patience in sharing this valuable knowledge, Sir. - From Burma
I accidentally created a virus from your data!! It will automatically run 500k data because i didnt correctly put the validation and use update button.
Hi Pedia,
1, Could you please update the download link? Its now unaccessible.
2, The code should be "Dim lr As Long", right?
I need code all for commandbutton
Me too bro
I have a problem on the caller. Everytime i call the sub refresh data im having error
We're sorry. You can't access this item because it is in violation of our Terms of Service.
Run in time error 380 showing.. resource problme bro.. how to recover the issue
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.
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
How to retrieve data without searching. Say, i double click the data from tge listbox - is this possible?
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.
sir, the file on drive can't access. May i get new file link? thanks before
Dear Sir,
Trying to run your "Employee Details Dynamic form" which looks great, however an error showed up.
It said:
"Error 2147352571 (80020005)
Cannot set up the characteristic (reference) ColumnWidths. Type doesn't match"
Looking in the code where the Error showed up, this line came up highlighted:
.ColumnWidths = "80,140,70,130,100,150,80,80"
Hope the can tell why and what to do.
Thank you in advance
Welcome Thank you very much Excellent and clear explanation I have a question I hope you can help me.
I have a problem that I could not solve. The problem is as follows (duplicate data): I have created a database in VBA. And I worked in it a button to search, a button to save, a button to query, a button to edit, a button to open a file, and a button to exit. The problem is that the data gets duplicated from the edit button. As for the data save button, I used code to not duplicate the data and it worked and no longer accepts any duplicates. The recurrence occurs from the modification button when I query the data of an employee who already exists (i.e. whose data has been previously entered), and I modify his data with the same data of another employee who is also present in the same database. It saves the modification and migrates the data to the sheet or database, the data duplication occurs and this is the problem I'm having.
I used the no-repeat code I used for the save button But it didn't work properly Please help me
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
th-cam.com/video/0ogv43DSzdo/w-d-xo.html
@@sagar.banjade.5 Thank you!
Informative.
Your tutorial is nice, but I am unable to get Cells option in command With sh and next row .Cells. Please guide me
Awsome video….how to send search data through outlook kindly advise
source code?
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
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
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?
Nice
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.
Wow! Great Video
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
i tried to make it but i get some issues over there. kindly give link for download sir...thanks Ali here
Nice dude and thanks
you are legend brother. easy and straight to the point.
Thanks a lot could you please share file
Thankyou so much for brilliant userform. But pls let me know how do I search data from multiple sheets. Regards
Is there anyway to download the code settings pls???
How do I contact you privately for assistance?
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
why i click save it not drop the data after column name ? i do as the same yours
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
Your provide customized software
I wants to express my profound appreciation to this super tutorial. Thank you Sir!
Teşekkürler Türkiye den Selamlar
how do I change the coding for the search function to search data from any field?
how come when you click the (32:17) listbox and delete the code, it shows the refresh data? thank you
Please provide source code of this video
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 ?
when i try to save the data, it closes the userform..... if i remove call refresh data, then it works ok, but it doesnt show list box at start of userform....However, update button works efficiently it does not close userform nor it closes listbox
no reply from any one
can you please attach the code which used in this userForm
Download not working, it is banned.
How to display same names in list box
Print and export to pdf
Code in this form please tell me sir
thank you so much. this video helped me a lot.
How to get the data entry form software.