This particular form is quite useful. I have been developing a database around this exact form only adding more columns and logging data for each transaction on another sheet with special codes for tracking location of items. I was able to increase the number of columns to 12. The majority of it works really well. I had a problem searching columns that contained only numbers and gave up on it. For some reason search only works on text type data. I ended up just adding one letter to the front of the number to get the search working but then I gave up proper sorting of the numbered columns. Very frustrating. In any case I love watching your projects that you have put together.
Hi Trevor, Don't take the following in the wrong way, it is constructive criticism. You present these great projects in piecemeal explanation, and thus those who attempt to follow these projects only come to understand it in piecemeal. Some will take it on board right away, but others will struggle. You need to coherently articulate every single line of code; what it is, what it does, and where it points to. Don't assume that everyone knows what you trying to convey. If you don't want to explain everything, then you need a disclaimer stating what level of user you are presenting these projects for...easy, intermediate, advanced. Of course, this will extend the length of the video. You're good, but you could be awesome!
Hi There are 3 tutorials and multipl videos on this project. Here is the link to the first. Links to 2 and 3 are on this page. www.onlinepclearning.com/excel-advanced-filter-employee-database/
Great videos, thanks for putting those together! Question: What do I have to change if want to enter data for the same record using multiple pages on the form, where each page shows different fields. I have a lot of fields, which not all will be used in all cases.
Hello Trevor, Love your tutorials!! I'm a newbie on user forms and coding itself. At the moment Im just using it to entertain myself and if I get good at it, maybe it could be a way of income, who knows. I'm running excel on a mac and it is slightly different from PC. Example at the moment I'm stuck on ColHeaders on the tutorial cause my excel doesn't hace a RowSource input. Is there a way I could go around that using a code? Please help. Thank so much..
Love your tutorials! I have learned so much! I have modified this WB to suit a parking lot information database for my school. However, when I hit the cmdGetContact I always get the "error" message "no match found". Behind the multi-page userform I can see nothing has changed. When I close the userform. The data fills into the "outdata" and the search information changes in the 2 cells I've designated for the search. But it will not fill that data into the userform. Any ideas?
Hi Sir your videos are awsome. i need your assistant .I have created a multipage user form. and in that first page is homepage. in homepage i have added command buttons. now i want if i will click on button it should show that page that i want. from multipage. i have named rad as command button in homepage . and one page name is also rad in multipage userform ,so if i will click on rad command button then it should go to rad page . please tell me how to do that
no issue i got reply from sumit bansal. he has lot of videos regarding excel. but i have explained in English to him also . may be i am bad in explaining. sorry :)
Hey Trevor, thank you for this amazing tutorial...have been following your blog as well and have really learnt a lot.truely appreciate you sharing your knowledge..i have built something based on the employee database..and the add to database feature works perfect..I am though facing a problem with the get contact button...if i pull up the search on the database it works fine and copies the data im searching on to the other side in the database...however when i launch the form and try to search any data the grayed text box displays the correct column header but doesn't display the information in the list box...no errors instead it gives the the no match found error...I do have 270 columns though so im not sure if the list box even supports it...Could really use your help here...Thanks in advance...
+Savio Fernandes : Hey Trevor...fixed it...was a problem with the data ...i think the data was corrupt...fixed that and it works perfect.Again...amazing tutorial...thanks again for sharing the knowledge
Hi Trevor, Thanks for this tutorial & others.They are really helping us. I am trying to use this code for some other database but facing challenge in searching the data & then extracting it. Please if you could share me the .xlsm file then I could check if I am missing anything. I am facing problem at advancefilter code. thanks.
Hello, I'm trying your form but when I run it. I get the following error. Run-time error '-2147220995 (800401fd)': Cant move focus to the control because it is invisible, not enabled, or of a type that does not accept focus I have looked and my form and all of the labels, text boxes and drop down boxes are enabled. Any help would be great.
Hi chris To set focus to an object in a different page on a multipage you need to write two lines of code. MultiPage1.Value = 1 'page numbers begin at 0 txtIc.SetFocus hope this helps
Hi Trevor. i already try to create Vba form as in video. i am facing some problem. I could not save the time sheet. i really need this database for employee used. second problem to enter formula quite difficult .please help me on this
Hi, I am new to VBA but I would like to know if I can create a payroll system with VBA that will automatically create a new-sheet with the name of every employee that I added this sheet will consist of formulas and keep the monthly record for the employee.
Hi Kadian, it would depend very much on the size of your organization. For anything but a very small company a relational database would be a better option. best wishes Trevor
hi Trevor or anyone? I am a VBA novice and so far I have followed exactly what tutorial videos taught. Everything seem fine. However when I come to last step of this video, after assigning macro, i opened the "Userform" and clicked on "Get Contact", it get stucked during execution. Error msg saying "Compile error: Sub or function not defined" under the "Private Sub cmdContact_Click()". Error come when it trying to execute "unprotect" or "protect" sheets. I checked the video and location of this code is correct, at the same way. Anyone can help?? Thanks
Hey trevor, im facing a problem or actually 2. ones i try to clear data at the second page when adding employees i'll get an error at clear ->Private Sub cmdClearme_Click() 'clear all controls Clear
HI Trevor i want to create one of VBA project for office can you help me out i know your are best in VBA here is some details example:- all date save in MS access and create a form in excel for entry and when the any one want to next work then he click on next button then its fetch next no.
Hi Trevor. I have gone through the video to get the concept of your tutorial. However, I seem to have a challenge with the Error Handler. Everytime i try to add the Employee (Add Employee), i can't execute the code. It keeps bringing up a compile error dialogue box advising "Sub or Function not defined". Where could i be getting it wrong?
+Trevor Easton Thanks for your response. I am using the template you provided and the code is as was shared. Initially I thought the error had to do with references.
I think there is a problem on the search code. The search data is not showing because it is not lifting the data from the source to the filtered data area. I hope someone shed light on how to deal with this.
Another question, i;ve fixed the 2 problems however i do have another problem. When i click a on a contact it doesnt shows me the information in the edit part. How can i link my text cells to the found contact
Hi Diego, You need to double click. The code is in the web article. Private Sub lstEmployee_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Here is the link. www.onlinepclearning.com/edit-and-delete-from-a-userform/ Best wishes Trev
I am currently starting my freelance accounting services and I am interested in designing a database that can assist me with the processing for both small and large organisation. Can you provide me with the link for the videos that can assist me with the design?
Hi Kadian, That is a very general question. Probably the best thing few to do s to go to the homepage of my website and on the right-hand panel there is a search box. Type in the keywords that you are looking for and that will take you to tutorials on that subject. Best wishes Trevor
Question: How is the Private Sub "CboHeader_Change" applied or triggered by the user or userform? There's nothing that links this subroutine to the userform.
Dear Trevor, Thank you very much for your efforts. I made this employee database successfully. But when I try to save data in page 2 clicking on Add Employee following error message comes up although the data is saved: "Error 1004 (Reference isn’t valid) in procedure cmdClear_Click of Form EmployeeDB". How to solve the same? Please advise
Hi Rafeeque, That is an object based error. Are you using the template unaltered? Maybe referencing the wrong sheet?? There is a request support page on the website. Trev
Hi, That makes things a bit difficult. Check the the sheet reference is correct for your file. My code uses the sheet code name not the sheet name. The code name is to the left of the sheet name in the VBA explorer. This may be the problem. Best wishes Trev
thank you for your prompt response!. God reward you the best! Can you please send me the template by emai if you don't mind? my email: rhudavi@gmail.com
I created your forms and codes but have an issue with the search combo box in the search edit delete Private Sub cboHeader_Change() 'dim the variable Dim LBEmployee As Worksheet 'set the variable Set LBEmployee = LBEmployee 'establish the condition for "All_Columns" If Me.cboHeader.Value = "All_Columns" Then LBEmployee.Range("M1") = "" Else 'clear the textbox Me.txtAllColumn = "" 'add the criteria header to the sheet It does not like my range the row below LBEmployee.Range("M1") = Me.cboHeader.Value 'clear any existing criteria LBEmployee.Range("M2") = "" End If End Sub
Hi Sir Trevor. Great Tutorials as always. :D Ahm I tried to make a Search function using your code but it seems mine is always got to "No Match Found". I can't seem to understand why it always go to the error handler. please help me huhu
ahm i made my own but its similar to yours. i rewinded the video for how many times now but still cant find whats wrong with my code. can i email my form to you?
+Trevor Easton i think i found the problem sir but i cant seem to understand. the name range which is the outdata (=OFFSET(Data!$N$9,0,0,COUNTA(Data!$N$9:$N$9989),7)) what is the meaning of this? i cant undestand huhu
+Trevor Easton please help me sir. i really stuck on the name range "outdata". i think its the one that i cant undestand. i really badly need it sir huhu. thank u
hi Ravi, There is a contact page on my website that emails me. However , I do not have the available time to modify my projects to suit individual needs. I receive a huge number of requests to do this. Obviously this is not feasible nor reasonable for me to do this. If you are working through a project on my site and are using the template and have not changed it THEN I can offer support and help as my time permits. Best wishes Trev
Hi Jean, I. Can offer you some support if you are using the template and code unmodified. I recieve many requests each day to modify code for people and companies. Unfortunately I do not have the resource to do this. Trev
Dear Mr trevor i have this project and i follow all conditions from your vedio but an error accured in project plz help me the error is Compile error is hidden module: EmployeeDB kindly help me thanks
Hi You can complete the tutorial by downloading the template and following the instructions on the website. I do not supply completed files. Best wishes Trev
![VICTOR Denmark Open 2024 | An Se Young (KOR) [1] vs. Gregoria Mariska Tunjung (INA) [5] | SF](http://i.ytimg.com/vi/Y3QEyCih85s/mqdefault.jpg)
This particular form is quite useful. I have been developing a database around this exact form only adding more columns and logging data for each transaction on another sheet with special codes for tracking location of items. I was able to increase the number of columns to 12. The majority of it works really well. I had a problem searching columns that contained only numbers and gave up on it. For some reason search only works on text type data. I ended up just adding one letter to the front of the number to get the search working but then I gave up proper sorting of the numbered columns. Very frustrating. In any case I love watching your projects that you have put together.
Hi Trevor, Don't take the following in the wrong way, it is constructive criticism. You present these great projects in piecemeal explanation, and thus those who attempt to follow these projects only come to understand it in piecemeal. Some will take it on board right away, but others will struggle.
You need to coherently articulate every single line of code; what it is, what it does, and where it points to. Don't assume that everyone knows what you trying to convey. If you don't want to explain everything, then you need a disclaimer stating what level of user you are presenting these projects for...easy, intermediate, advanced.
Of course, this will extend the length of the video. You're good, but you could be awesome!
Hi
There are 3 tutorials and multipl videos on this project.
Here is the link to the first. Links to 2 and 3 are on this page.
www.onlinepclearning.com/excel-advanced-filter-employee-database/
My sincerest thank you Sr.
your tutorials are so helpful for me. Keep it up!
Great videos, thanks for putting those together! Question: What do I have to change if want to enter data for the same record using multiple pages on the form, where each page shows different fields. I have a lot of fields, which not all will be used in all cases.
You're the best Mr. Easton! These tutorials are AWESOME! Thank you for all your help!
p,s great tutorials by the way very easy to follow once I got them into line thanks great effort
Hello Trevor,
Love your tutorials!! I'm a newbie on user forms and coding itself. At the moment Im just using it to entertain myself and if I get good at it, maybe it could be a way of income, who knows.
I'm running excel on a mac and it is slightly different from PC. Example at the moment I'm stuck on ColHeaders on the tutorial cause my excel doesn't hace a RowSource input. Is there a way I could go around that using a code? Please help.
Thank so much..
Love your tutorials! I have learned so much! I have modified this WB to suit a parking lot information database for my school. However, when I hit the cmdGetContact I always get the "error" message "no match found". Behind the multi-page userform I can see nothing has changed. When I close the userform. The data fills into the "outdata" and the search information changes in the 2 cells I've designated for the search. But it will not fill that data into the userform. Any ideas?
I’m having the same erorr with cire411did you get the answer?
@@michelleramirez1335 Have you fixed this?
Hi Sir
your videos are awsome.
i need your assistant .I have created a multipage user form. and in that first page is homepage. in homepage i have added command buttons. now i want if i will click on button it should show that page that i want. from multipage.
i have named rad as command button in homepage . and one page name is also rad in multipage userform ,so if i will click on rad command button then it should go to rad page . please tell me how to do that
Hi Santosh,
I am not sure that I understand what you want to do.
Best wishes
Trev
no issue i got reply from sumit bansal. he has lot of videos regarding excel. but i have explained in English to him also . may be i am bad in explaining. sorry :)
Hey Trevor, thank you for this amazing tutorial...have been following your blog as well and have really learnt a lot.truely appreciate you sharing your knowledge..i have built something based on the employee database..and the add to database feature works perfect..I am though facing a problem with the get contact button...if i pull up the search on the database it works fine and copies the data im searching on to the other side in the database...however when i launch the form and try to search any data the grayed text box displays the correct column header but doesn't display the information in the list box...no errors instead it gives the the no match found error...I do have 270 columns though so im not sure if the list box even supports it...Could really use your help here...Thanks in advance...
+Savio Fernandes : Hey Trevor...fixed it...was a problem with the data ...i think the data was corrupt...fixed that and it works perfect.Again...amazing tutorial...thanks again for sharing the knowledge
Hello sir.
your video tutorials is learnable to public field.i want to know how I could make exceel database antry for accounts
trev, do u also have sample videos on northwind database using vba especially on UnitInStock, UnitInOrder, etc.
Hi Trevor, Thanks for this tutorial & others.They are really helping us.
I am trying to use this code for some other database but facing challenge in searching the data & then extracting it. Please if you could share me the .xlsm file then I could check if I am missing anything. I am facing problem at advancefilter code. thanks.
Hello,
I'm trying your form but when I run it. I get the following error.
Run-time error '-2147220995 (800401fd)':
Cant move focus to the control because it is invisible, not enabled, or of a type that does not accept focus
I have looked and my form and all of the labels, text boxes and drop down boxes are enabled.
Any help would be great.
Hi chris
To set focus to an object in a different page on a multipage you need to write two lines of code.
MultiPage1.Value = 1
'page numbers begin at 0
txtIc.SetFocus
hope this helps
What happened to Trevor and Online Pc Learning, he made realy great tutoriels.
Hi Trevor, i made a very similar interface and code as shown in this tutorial but it did not work. I hope you can help me
Sir
Really useful
What is the VBA code to high light the list box data based on conditions
Hi Trevor. i already try to create Vba form as in video. i am facing some problem. I could not save the time sheet. i really need this database for employee used. second problem to enter formula quite difficult .please help me on this
Hi, I am new to VBA but I would like to know if I can create a payroll system with VBA that will automatically create a new-sheet with the name of every employee that I added this sheet will consist of formulas and keep the monthly record for the employee.
Hi Kadian,
it would depend very much on the size of your organization. For anything but a very small company a relational database would be a better option.
best wishes
Trevor
How Can I make my complete vba a project run on a network such that, items sold by client 1 will show on client 2 instantly?
Thank you very mush.
hi Trevor or anyone? I am a VBA novice and so far I have followed exactly what tutorial videos taught. Everything seem fine. However when I come to last step of this video, after assigning macro, i opened the "Userform" and clicked on "Get Contact", it get stucked during execution. Error msg saying "Compile error: Sub or function not defined" under the "Private Sub cmdContact_Click()". Error come when it trying to execute "unprotect" or "protect" sheets. I checked the video and location of this code is correct, at the same way. Anyone can help?? Thanks
Thanks I was looking for how to sort by surname
Hey trevor, im facing a problem or actually 2. ones i try to clear data at the second page when adding employees i'll get an error at clear ->Private Sub cmdClearme_Click()
'clear all controls
Clear
HI Trevor i want to create one of VBA project for office can you help me out i know your are best in VBA here is some details example:- all date save in MS access and create a form in excel for entry and when the any one want to next work then he click on next button then its fetch next no.
nice tutorial
Hi Trevor. I have gone through the video to get the concept of your tutorial. However, I seem to have a challenge with the Error Handler. Everytime i try to add the Employee (Add Employee), i can't execute the code. It keeps bringing up a compile error dialogue box advising "Sub or Function not defined". Where could i be getting it wrong?
Hi Paul,
Are you using the template that is provided. Have you altered it or the code?
Trev
+Trevor Easton Thanks for your response. I am using the template you provided and the code is as was shared.
Initially I thought the error had to do with references.
Hi Paul,
The info on the web article is fine. If you can not resolve your issue then you can contact me on the support page of the website.
Trev
Thank you so much. I will keep in touch
Unprotect_All compile error
also not show any thing in combobox
how creat interface page like search option
I think there is a problem on the search code. The search data is not showing because it is not lifting the data from the source to the filtered data area. I hope someone shed light on how to deal with this.
Another question, i;ve fixed the 2 problems however i do have another problem. When i click a on a contact it doesnt shows me the information in the edit part. How can i link my text cells to the found contact
Hi Diego,
You need to double click.
The code is in the web article.
Private Sub lstEmployee_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Here is the link.
www.onlinepclearning.com/edit-and-delete-from-a-userform/
Best wishes
Trev
I am currently starting my freelance accounting services and I am interested in designing a database that can assist me with the processing for both small and large organisation. Can you provide me with the link for the videos that can assist me with the design?
Hi Kadian,
That is a very general question. Probably the best thing few to do s to go to the homepage of my website and on the right-hand panel there is a search box. Type in the keywords that you are looking for and that will take you to tutorials on that subject.
Best wishes
Trevor
Thank you
HOW TO APPLY THE "AUTO OPEN" ON THIS USERFORM WITH MULTIPAGE? AND HOW CLOSE AND SAVE THE SAME USERFORM WITH A BUTTON?
Question: How is the Private Sub "CboHeader_Change" applied or triggered by the user or userform? There's nothing that links this subroutine to the userform.
Hi Larry,
The event is triggered when a value is changed in the combobox.
Trev
So you can trigger an event without the user physically doing something? Are there more example of this for future reference?
Hi Larry,
Here is a tutorial.
www.onlinepclearning.com/vba-for-beginners-vba-objects/
Look at "what are events"
Hey again. I was about to solve that issue. I'm working on another project and want to know if you can give me some assistance?
Trevor Easton, I want to download this file (clip which you share above...)
Thanks so much!
sir in the list data the title is not showing i mean the surname firstname etc. what to do? thanks..
HOW CAN I GENERATE ATTENDANCE ON ONE EXCEL SHEET AND SELECT NEW SHEET.AND HOW CAN I PREVIOUS MONTH ATTENDANCE SEE THIS SHEET
Dear Trevor,
Thank you very much for your efforts. I made this employee database successfully. But when I try to save data in page 2 clicking on Add Employee following error message comes up although the data is saved:
"Error 1004 (Reference isn’t valid) in procedure cmdClear_Click of Form EmployeeDB". How to solve the same? Please advise
Hi Rafeeque,
That is an object based error. Are you using the template unaltered?
Maybe referencing the wrong sheet??
There is a request support page on the website.
Trev
sir, the web is not openable from UAE
I just made myown sheet and working on this as illustrated in the tutorial video
Hi,
That makes things a bit difficult. Check the the sheet reference is correct for your file. My code uses the sheet code name not the sheet name. The code name is to the left of the sheet name in the VBA explorer. This may be the problem.
Best wishes
Trev
thank you for your prompt response!. God reward you the best! Can you please send me the template by emai if you don't mind? my email: rhudavi@gmail.com
Sir Trevor, how could I make my own userform w/ the same contents as you shown without a new template? thaanks sir!
I created your forms and codes but have an issue with the search combo box in the search edit delete Private Sub cboHeader_Change()
'dim the variable
Dim LBEmployee As Worksheet
'set the variable
Set LBEmployee = LBEmployee
'establish the condition for "All_Columns"
If Me.cboHeader.Value = "All_Columns" Then
LBEmployee.Range("M1") = ""
Else
'clear the textbox
Me.txtAllColumn = ""
'add the criteria header to the sheet
It does not like my range the row below
LBEmployee.Range("M1") = Me.cboHeader.Value
'clear any existing criteria
LBEmployee.Range("M2") = ""
End If
End Sub
Hi Mr. Trevor? are you still alive? hope you reply thanks
Sir
can upload as a excel file which is above showing if you can, it will be very easy to understand me
Hi Sir Trevor. Great Tutorials as always. :D
Ahm I tried to make a Search function using your code but it seems mine is always got to "No Match Found". I can't seem to understand why it always go to the error handler. please help me huhu
Hi
There is a template with the tutorial on the website. You can use it complete the tutorial.
Also a support page.
Trev
ahm i made my own but its similar to yours. i rewinded the video for how many times now but still cant find whats wrong with my code. can i email my form to you?
+Trevor Easton i think i found the problem sir but i cant seem to understand. the name range which is the outdata (=OFFSET(Data!$N$9,0,0,COUNTA(Data!$N$9:$N$9989),7)) what is the meaning of this? i cant undestand huhu
+Trevor Easton please help me sir. i really stuck on the name range "outdata". i think its the one that i cant undestand. i really badly need it sir huhu. thank u
Hi ,
Here Is a tutorial with a sample file you can download.
www.onlinepclearning.com/excel-dynamic-named-ranges-6-types/
Best wishes
Trev
hi Can you make some tutorials for complete beginners from scratch thanks
Hi Sir,
where can i copy the entire code on cmdadd user form
Here is the link
www.onlinepclearning.com/multi-page-userform-employee-database/
sir you have not shown the delete employee from the lisy
sir is there a way to communicate with you. need help badly for my project.
Sincerely,
Ravi James
hi Ravi,
There is a contact page on my website that emails me.
However , I do not have the available time to modify my projects to suit individual needs. I receive a huge number of requests to do this. Obviously this is not feasible nor reasonable for me to do this.
If you are working through a project on my site and are using the template and have not changed it THEN I can offer support and help as my time permits.
Best wishes
Trev
Dear Mr trevor i didnot fine cmdclear code kindly submit code here
sir great tutorial but i did everything it don't want to work for me please help i really like your projects
Hi,
There is a request support page on my website.
Please supply all the info requested.
Trev
i did yersterday, i just want to show you my code please
Hi Jean,
I. Can offer you some support if you are using the template and code unmodified. I recieve many requests each day to modify code for people and companies. Unfortunately I do not have the resource to do this.
Trev
yes i'm using your template
Anyone on 2023 has the code of this data or have any suggestion of an update video
Please sir,kindly send me the IstEmployee code
Dear Mr trevor
i have this project and i follow all conditions from your vedio but an error accured in project plz help me
the error is
Compile error is hidden module: EmployeeDB
kindly help me thanks
Hi
There is a support page on the website if you want support for a project.
Trevor
Dear mir Trevor thanks for your help
now whenever i click get contact so then an error is showing
and the error is No Match found
ok thanks mir Trevor
sir did you found the problem? i got the same error please help!
Sir Please Send me this file please
Hi
You can complete the tutorial by downloading the template and following the instructions on the website. I do not supply completed files.
Best wishes
Trev