Participant Contact Database: Help with Search and Editing Data Entries

Hello Everyone,

I am super new to the VBA and programming world (i.e. this is my first time ever putting together a project and I have ZERO background in it. I am a Counselor by trade, so be gentle). PLEASE HELP!! I have reached out to my the Computer Science program at my local university and NO ONE has even responded to me. I am in a time crunch now to get this set up, so our research lab can go paperless and enter the 21st century!

My task: to create a database that houses research participant information with a new entry form and the capacity to search and edit information that is already entered in the spreadsheet (any columns, any text, as we can't have duplicate entries and as participants come back for multiple studies, and/or their contact information changes). Note: It is an infant research lab and it is of utmost importance to search all possible matches because sometimes, although infrequently, an infant dies and we DO NOT want to be contacting those parents to participate in studies.

So far, I have created a form that populates new entries; however, I cannot figure out the search function and edit (with SAVE button) information that is found. The search isn't working and highlighting a certain contact in the spreadsheet does not populate the data in to the form.

PLEASE HELP!! I have been watching hours worth of Youtube videos, all coding this differently, and so far, none of them are working. I will attach my Excel Macro Book. There is no Real Data yet in the spreadsheet.

Additional Inquiry:
Sidenote: I would like the ID # spot to auto-populate with a new sequential # each time a New Entry is added. It was working for a hot second, then it stopped.

Thank you in Advance!!!!

Hi.
Have a play around with the attached, the listbox acts as the 'search' platform.
The 'unique' id is created using 'forename' initial + 'surname' initial + two digit random number.
To enter 'new' person first 'CLEAR' form > enter details > press 'NEW' > data is stored > list sorted and added to listbox.
To 'update' or 'delete' simply chose from listbox and carry out actions.
I noted although your data was in a 'Table' your coding used 'ranges' to add new detail and the range find was restricted to 65,000 ???
Using 2016 and .xlsm you can use 1m + rows of data, if you use 'Table' features the tables can be increased/decreased without need to keep finding the range size.
Hopefully there is enough self-explanatory code to aid your initial save/update/delete query.
Lastly use 'Option Explicit' as your very first line of code, this will help you id missing variables when you debug.
happy coding.
torachan.