Search and Edit existing data in UserForm

[KC0LE]

Hello,

I have a created a userform for my spreadsheet that tracks certain events. Feilds include things like member name, member number, date of event, comments, ect.

At the moment, I have managed to write the code to add new records into my spreadsheet using a "RowCount" function, and can search existing records(kind of), through a "MySearch" function.

I want to be able to edit existing records, saving the changes in it's original row. Also when I search for records to populate my form, I need to be able to move through the existing rows.

I would like my UserForm to be able to:
Add New Records
Search Existing Records via search criteria
Edit existing records from the UserForm


Please help!
Thank you