Trevor, thanks so much for all the videos and tutorials. Awesome work and your steps are very easy to follow. I've adapted a few of your templates to fit my own needs and every single one of them work great. Again, thanks so much!
Dear Trevor, This is truly a piece of art. I've been playing and pausing your tutorials over and over a trillion times and learnt a lot! Thank you so much. I'm glad I had to put all the coding and user controls in myself rather then copy/paste from your website. I've adjusted the form to my needs without much trouble. I would like to add a bit more and hopefully you can help me with that as I cannot figure it out myself (been trying for days now) All the rows in my database have a Status (Active, Stopped, Draft, Inactive) I would like to add these in option buttons (and 1 button for All) so that when the user searches for a particular (let's say city) and option Active was selected it would only show lines from that search with Status Active. Small note: Active would be the default. Hopefully you are able (and willing) to guide me with this so I can proceed with this userform. Anyhow...thanks again for sharing your time and insights on your channel/website.
how can avoid duplicity.... i use one text box and one combo box( i.e Date & shift ( A,B,C) if Data available (suppose 12/8/2017 & shift A) it will give error msg...but when i type 12/8/2017 Shift B...data will store in sheet 1)
Hi Trevor. Thank you ever so much for the valuable videos. I were wondering if you have a solution to checkbox overlapping when filter applied in excel?
Trevor Easton, please when I got to the rowsource and I entered colHeaders there is always an error that could not set rowsource. invalid property value. please could you please help me out
hello there trevor, i appreciate your tutorial a lot, i only have 1 question... when i try to run the contact in the userform there is an error box that pops up saying COMPILE ERROR: METHOD OR DATA MEMBER NOT FOUND from the vba code page where you type all the codes... can you help me try to fix this error. appreciate your kind response.
Hi Trevor, this is Razak. I had problems with the rowsource for the combo box. there's an error that could not set rowsource. invalid property value. please could you help me out
Hello Trev, is it possible to provide us with the complete userform? Graphics plus appropriate code? (not just the initial template) Then we can follow the rest of the tutorials. Many thanks for your tutorials.
Trevor... can you advise me on how I get the template etc. I would love to follow along but do not seem to be able to find a link to the template etc. Thanks. Your courses are amazing! MozZ ;-)
Hi Trevor, I like your videos a lot, I have developed several Projects taking as a model some of your videos, in fact I am using a big Userform Interface for the company I am working currently.... I currently involved in a big project and I want to know if it is possible to open one instance of Excel if the workbooks belongs to my macro, but if is NOT then open a different instance.... in another words it is like I have two independent Excels: One for my macro (it allows only the files that I open using my macro), and the... Second Excel only for the workbooks I try manually open that do not belongs to my macro.Any comment I will really appreciate... Sorry but this one is the only way I found to ask you this concern.
Hi I'm Momin from India, big fan of your work. I wish to add three fields extra. These are 1. Employee picture 2. Employee signature 3. Export filter file to another excel file. Please
Thanks for this, its giving me an idea. But I want it to make simple and I'm doing it in activex controls. Is there a code if I use it in activex controls? And theres a way that can I view multiple sheets in one listbox but view one at a time using command button. Is there an email address where can I send my project?
Hi Geno, All Userform controls are active X controls. You may be able to change the row source for your Listbox with a command button. You could view data on different sheet this way. Best wishes Trev
+Trevor Easton I mean I want to do it in worksheet instead of userform cause userform has limited size. And I tried it in sheet, get contact and clear button are not working error 438. By the way Thank!
Great work!, this tutorial saves a lot of my time for research! just need to know where is the part 1 where I can setup the sheets where the data will be stored. Thanks!
Thanks Trevor!, I did the Advance filter with the "*" to automatically give me the results, however it does not give any results. I am using both 2016 and 2007 to test my project, It would be really great if the wildcard search will work as I do not have to make differnet search combinations. Thank you!
Sir, I cant Change the row source in combobox search to ColHeaders. its telling me that Invalid Property Value. Thanks In Advance for your reply. This Is a great help. Thanks again.
Hi Trevor, thanks so much for all the videos and tutorials. I will try to do 24 columns in add employee then I got an error like this Error 438 (Object doesn'ssupport thispropery or method) in procedure cmdClear_Click of Form EmployeeDB so please give a solution for this error.
Glad you didn't just include a link for the final version. Means we've all had to do the hard work!
Trevor, thanks so much for all the videos and tutorials. Awesome work and your steps are very easy to follow. I've adapted a few of your templates to fit my own needs and every single one of them work great. Again, thanks so much!
+Nicholas White
Thanks Nicholas,
Appreciate the feedback.
Best wishes
Trev
Dear Trevor,
This is truly a piece of art. I've been playing and pausing your tutorials over and over a trillion times and learnt a lot! Thank you so much. I'm glad I had to put all the coding and user controls in myself rather then copy/paste from your website. I've adjusted the form to my needs without much trouble.
I would like to add a bit more and hopefully you can help me with that as I cannot figure it out myself (been trying for days now)
All the rows in my database have a Status (Active, Stopped, Draft, Inactive) I would like to add these in option buttons (and 1 button for All) so that when the user searches for a particular (let's say city) and option Active was selected it would only show lines from that search with Status Active. Small note: Active would be the default.
Hopefully you are able (and willing) to guide me with this so I can proceed with this userform. Anyhow...thanks again for sharing your time and insights on your channel/website.
how can avoid duplicity.... i use one text box and one combo box( i.e Date & shift ( A,B,C) if Data available (suppose 12/8/2017 & shift A) it will give error msg...but when i type 12/8/2017 Shift B...data will store in sheet 1)
Hi Trevor. Thank you ever so much for the valuable videos. I were wondering if you have a solution to checkbox overlapping when filter applied in excel?
What is the VBA code to high light the list box data based on conditions
Hi, Trevor, how can I download the files for this user form? is your web site working?
Trevor Easton, please when I got to the rowsource and I entered colHeaders there is always an error that could not set rowsource. invalid property value. please could you please help me out
Awesome tutorial trevor...learnt a lot...
hello there trevor, i appreciate your tutorial a lot, i only have 1 question... when i try to run the contact in the userform there is an error box that pops up saying COMPILE ERROR: METHOD OR DATA MEMBER NOT FOUND from the vba code page where you type all the codes... can you help me try to fix this error. appreciate your kind response.
Which video is the first in this series? Can you share the link? Thank you.
Hi Trevor, this is Razak. I had problems with the rowsource for the combo box. there's an error that could not set rowsource. invalid property value. please could you help me out
Thanks Trevor - this is really useful.
Thanks very much _Trevor, you are helping me so much!!!!
Thanks again!!!!
Hi Edgar,
Thanks for the positive feedback.
Trev
Thanks Trevor for this valuable information.
HI Trevor,
Where I can find the lessons previous to this videos?
Thanks,
Ramon
Hello Trev, is it possible to provide us with the complete userform? Graphics plus appropriate code? (not just the initial template) Then we can follow the rest of the tutorials. Many thanks for your tutorials.
Very useful,
Thank you Trev
Thank you for the effort.
Very good work.
God bless you.
Please sir, how did you add a picture of you interface
Can i get the template which you have created in this Video?
Good afternoon sir.
Please can you kindly let me know how you begin the first step to create the excel before the userform and codes
Trevor... can you advise me on how I get the template etc. I would love to follow along but do not seem to be able to find a link to the template etc. Thanks. Your courses are amazing! MozZ ;-)
thank u really good and very useful thank you sir
Great work
Thanks for sharing your knowledge
Hi Trevor, I like your videos a lot, I have developed several Projects taking as a model some of your videos, in fact I am using a big Userform Interface for the company I am working currently....
I currently involved in a big project and I want to know if it is possible to open one instance of Excel if the workbooks belongs to my macro, but if is NOT then open a different instance.... in another words it is like I have two independent Excels:
One for my macro (it allows only the files that I open using my macro), and the...
Second Excel only for the workbooks I try manually open that do not belongs to my macro.Any comment I will really appreciate... Sorry but this one is the only way I found to ask you this concern.
Thank you very hard and your next videos.
Hi Trevor. Great work are there any more projects in the pipeline?
Hi I'm Momin from India, big fan of your work. I wish to add three fields extra. These are
1. Employee picture
2. Employee signature
3. Export filter file to another excel file. Please
thanks for this important tutorial
Appreciate your feedback.
😊
Thanks for this, its giving me an idea. But I want it to make simple and I'm doing it in activex controls. Is there a code if I use it in activex controls? And theres a way that can I view multiple sheets in one listbox but view one at a time using command button.
Is there an email address where can I send my project?
Hi Geno,
All Userform controls are active X controls.
You may be able to change the row source for your Listbox with a command button. You could view data on different sheet this way.
Best wishes
Trev
+Trevor Easton
I mean I want to do it in worksheet instead of userform cause userform has limited size. And I tried it in sheet, get contact and clear button are not working error 438. By the way Thank!
+Trevor Easton
Is there a simple code for get contact? Without combobox.
Great work!, this tutorial saves a lot of my time for research! just need to know where is the part 1 where I can setup the sheets where the data will be stored. Thanks!
Hi Knych,
You will find the template here.
www.onlinepclearning.com/excel-advanced-filter-employee-database/
Thanks Trevor!, I did the Advance filter with the "*" to automatically give me the results, however it does not give any results. I am using both 2016 and 2007 to test my project, It would be really great if the wildcard search will work as I do not have to make differnet search combinations. Thank you!
Excllent Job,
Hi Trevor, The template download link no longer works.
Hi Scott,
I checked and it download.
Trev
Hi Trevor, It must have been my computer. All is well now.
Great tutorial yet again Trevor!
Cheers
sir i have problem in combo box
Sir, I cant Change the row source in combobox search to ColHeaders. its telling me that Invalid Property Value.
Thanks In Advance for your reply. This Is a great help. Thanks again.
I have the exact same problem. Can anyone help?
great learning way
Software's name
Merci beaucoup
sir how to get code for edit and delete
You need to go to the website..
www.onlinepclearning.com/edit-and-delete-from-a-userform/
Hi Trevor, thanks so much for all the videos and tutorials.
I will try to do 24 columns in add employee then I got an error like this Error 438 (Object doesn'ssupport thispropery or method) in procedure cmdClear_Click of Form EmployeeDB so please give a solution for this error.
thank sir
Can u pls gv the vba code?
Code is here
www.onlinepclearning.com/multi-page-userform-employee-database/
Hi.
sir I need your help.
How to make it make complete video
There are several video for this tutorial.
Trev
I got nothing
Ahh Found it... Cool
I think Access i a hero for this type of projects not Excel
What is the use for this video without coding
My son 3 years old can do same
hey please give me the template
hey i have found your one
Can i get the template which you have created in this Video?