I have a userform that adds and deletes employees. The add button works but im not sure how to get the delete button to work. I have a defined name of "Employee" that is row "A". What I would like to happen is that when a employee is selected from a userform list and the delete button is pressed the employee is deleted and the form is updated. Any help is most appreciated. Thank you
Last edited by Khaos176; 12-19-2008 at 12:18 PM.
Try this
The example named range has a #REf error, so I changed the code for initialize
Please Login or Register to view this content.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you royUk for the quick reply. I have added the code for commandbutton1 and replaced the code for UserForm_Initialize. When I run the program it gives me a Run-time error '424': Object Required.
Works fine for me
Hmmm....Your right but the add employee now gives a Run time error '1004'
I've checked all the coded and made a few alterations
Please Login or Register to view this content.
Thanks a million!!!
It works great. Im going back to see what I was doing wrong. Thank you
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Found a problem. At first glance it seems to work fine but I noticed when adding employees my list is not getting bigger. Its replacing other names. Any ideas?
Hey, I played with it some, since it is similar to what I had/have been trying to achieve in the past. Still doing it.
I modified the codes a little, and should be great. I noticed if you accidently hit the delete button it would erase the top row.
Hope this helps you out
Last edited by dcraker; 12-18-2008 at 04:42 PM. Reason: size of file bloated
Thanks,
Davidyes, there is only one c
This amended code will add the name correctly
Please Login or Register to view this content.
So this is now working but I need to actually make a bigger form. I need to add a Job list which is the same as the Employee list. When I use the same concept I run into Run time error 1004.
It hasn't got the code in that I gave you, are you not using that?Originally Posted by Khaos176
I have been playing with all the ideas and got the last posts code to work for me. I did go back and tried playing more with the code you suggested and it still will not work. Thanks again for all your help. I didnt think this section of my program was going to be so difficult.
Ok I now see the problem. When the data lists are on a different sheet from the main button it is giving me the error. Ill keep trying.
The code works fine for me, I have amended the code so that it works for each task
I think thats it!!! Thank you again and again!!!
It should work from any sheet without selecting it.
I've also set it up to auto generate the next number so that you don't get duplicates, see the initialize code for the jobs textbox. If you delete a number it will still not re-use that number which should avoid confusion. If you use that I would set the textbox Enabled property to false
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks