Hello Everyone,
Basically I have learnt vba from scratch by piecing various things together and somehow I have managed to create what I need.
I have a spreadsheet which is populated by a userform. I have the next, previous, first and last record buttons so i can scroll through existing records.
However, I cannot find how to do the following and it is becoming very frustrating:
1. I need to be able to find a record by putting search terms in a text box
2. When I find the record, I need to be able to update it, delete some things if need be and then save the overwritten record on the same row using an update/amend command button. At present I can only save any overwritten records to a new line which is not what I want.
I have scanned the forum but cannot find a solution that does not add an additional row
Unfortunately because of restrictions on my (work) computer I am unable to attach a file. However I am very good at following examples so if someone has something similar that I can use then I would be very grateful. I can give a sanitized example of some of the code I am using though.
Your help would be much appreciated
The following is the code I use to populate the spreadsheet and add another record
The following code occurs when the form is intialized
The following is the code I use to move along records
I hope this all helps
Bookmarks