Search/Edit userform

johnpants

New Member
Joined
Oct 31, 2005
Messages
44
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

johnpants

New Member
Joined
Oct 31, 2005
Messages
44
Ok, reading through it, that seems more complicated then I think it is.

I have uploaded the file to the link below. If anyone that thinks they might be able to fix it or let me know the code I need to make it work I would be very much appreciative.

The problem I am encountering is that when I have done a search and it finds more than 1 record, the listbox is populated. When I highlight the one I want in the listbox and press 'select' I want it to automatically go to that record on the spreadsheet. At the minute it stays on the first record it finds, so I am unable to edit the one I select.

Hopefully this makes more sense.. :)

http://f6.grp.yahoofs.com/v1/oNB4Q2...p5P39RLvdREnKNh5JKVe005Z_A307xgKg/editrec.zip
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,936
Members
412,299
Latest member
agentless
Top