Hi, I have been given an example of a userform that can search and edit records, but am having a lot of trouble incorporating it into my workbook.
I have it working now, but there are a few small adjustments that I just cannot seem to work out.
Would anyone be kind enough to have a look at it and give me some suggestions/help please? I can only zip it up to 320kb without deleting necessary...
At the minute it searches fine and finds what I want it to. When it finds more that 1 instance it brings all of them into a listbox. The problem comes here, when I select the one I want to edit/delete from the listbox, it populates the textboxes on the user form, but when I go to apply the changes it amends the original record found in the search.
What I need is for the 'select' button to change the activecell to the one selected.. This will make more sense if you see the workbook..
Does anyone think they would be able to fix this or tell me what to do?
Sorry if this seems a little complicated, i'm coming to the end of this project now and trying to get the more technical parts working..
Thank you.
John
I have it working now, but there are a few small adjustments that I just cannot seem to work out.
Would anyone be kind enough to have a look at it and give me some suggestions/help please? I can only zip it up to 320kb without deleting necessary...
At the minute it searches fine and finds what I want it to. When it finds more that 1 instance it brings all of them into a listbox. The problem comes here, when I select the one I want to edit/delete from the listbox, it populates the textboxes on the user form, but when I go to apply the changes it amends the original record found in the search.
What I need is for the 'select' button to change the activecell to the one selected.. This will make more sense if you see the workbook..
Does anyone think they would be able to fix this or tell me what to do?
Sorry if this seems a little complicated, i'm coming to the end of this project now and trying to get the more technical parts working..
Thank you.
John