Hi All,
Wanted to know if it's possible to add a search button to this workbook... Assuming there are 100's of people in the list, wanted to be able to do a search
Is it possible with this type of setup?
John
Hi All,
Wanted to know if it's possible to add a search button to this workbook... Assuming there are 100's of people in the list, wanted to be able to do a search
Is it possible with this type of setup?
John
Last edited by JJFletcher; 11-23-2014 at 02:20 AM.
here is a macro that will ask you to enter some search parameter. It can be only a part of the name. The macro will look the EmployeeData sheet for an entry that fits your search. If a match is found then it will ask you if this is the employee your are looking for. You can answer either Yes, No or Cancel. If more than one entry fits your search, the macro will loop through all of them and ask you to make a choice. The only way out of this, if you don't see the employee you want, is the Cancel button.
If you click on Yes, the macro will put the employee number ic cell Q4 of the Dashbord sheet and you'll se his or her statistics.
Create a new button and assign this macro to it.Please Login or Register to view this content.
Hope this helps
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
This is great! It identifies the persons in the list - once the person is identified in the search function and the user selects yes - instead of posting data on the Dashboard worksheet, can it highlight the person in the list?
Last edited by JJFletcher; 11-22-2014 at 01:36 PM. Reason: correction in comment
Does anyone else have any thoughts besides Pierre?
Actually, this is what is does but you might not see it because the selection could be in the 3rd or 4th screen of the ListBox.
Anyway, you see the employee name in cell L9 just above the statistics.
Thanks Pierre for your response - so your code cannot be modified to highlight the name in the list rather then add data to the Dashboard?
It does highlight the name in the litsbox. Check this by searching for a name in the first screen. You'll se that it will be highlighted. I just can't find how to scroll the listbox to show the selected name.
Can you please upload the workbook you have added this to, I am not seeing this when I add it to the workbook
I am getting this error
error1a.JPG
Last edited by JJFletcher; 11-22-2014 at 06:13 PM.
here is a new workbook.
I changed the "FORMS Listbox" by an "ActiveX Listbox" which gives us more control.
I was able to program the find button so that the selected employee will be shown at the first row of the listbox.
I had to add a listbox_click event in the Dashboard sheet so that your dashboard works as it was before.
Hope this is up to your expectation.
Regards
Last edited by p24leclerc; 11-22-2014 at 08:58 PM.
Pierre,
When I attempt to launch the find an employee button the above error show! - Can't find project or library
Just enter the following code at the beginning of the macro
it should work.Please Login or Register to view this content.
Just enter the following code at the beginning of the macro
it should work.Please Login or Register to view this content.
I would like to Re - Address this thread.. An Obvious HOT HOT Subject...
So I would like to go farther...
The attached Workbook is a sample of what I am working with... Pierre's solution above worked and he has made the code work - yet in doing so, re-designing that small portion of code caused the remaining sheets to not function properly.
Pierre's Thoughts:
I changed the "FORMS Listbox" by an "ActiveX Listbox" which gives us more control.
I was able to program the find button so that the selected employee will be shown at the first row of the listbox.
I had to add a listbox_click event in the Dashboard sheet so that your dashboard works as it was before.
I would like to work with the attached Workbook code and allow the user the ability to Search for an employee without changing the current code structure and functionality...
HR Dashboard Modified V1.0.xlsm
Any Thoughts?
Best Regards,
John
I tied to purchase Commercial Services - yet the prompt I received when trying to pay is:
"Your account is limited. Please check your Account Overview page for messages about resolving this problem"
This is sent by [email protected]
How do I attain the Commercial Privileges - I want to address this issue...
John
Can one of the Moderators please respond to the last question?
Hi John,
would you please take a look at the attached workbook and see how it works for you. I did some testing and found no problem but you probably know better then me what to look at. It seems to be working just fine with the modifications I did.
If it does not work, can you point me to the specific problem so I can take a look at it.
Regards
Pierre,
Thanks for your feedback..
I really want to handle this issue and am willing to use the Commercial services - yet as you can probably see I have been having issues with getting it done - I will review and get back to you!
Best Regards,
John
I have tried to add this to another duplicate workbook and am getting a 400 error - the code works when I unprotect the sheet but get the error when protected - any thoughts?
Regards,
John
Unprotect the sheet at the beginning of the button macro and reprotect the sheet before ending it. You might have to manage some "Exit Sub" at some places in the code.
Hi JOhn,
forget about my previous message. After I give it a try, the error comes from the fact that in your original workbook, the cell R4 is unlocked. This is the only cell the macro uses.
When you added this to another duplicate workbook, cell R4 was locked by default thus the error when you run the find an employee macro.
Unlock cell R4 prior to protect the sheet and it should work.
Pierre,
That worked - Thanks a bunch..
I have additional questions when you have time
Regards,
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks