Code to Seacrh and Delete database records on UserForm

G'day Excel Gurus,

I'm new to VBA and creating UserForms. I am in the process of developing a pers data and NOK register for my workplace. I have set up a userform where the data can be entered and on pressing a save button on the userform, the data is stored in a worksheet. That works fine.

What I need is advise on how to create a 'search' code and a 'delete' code for two userforms. One userform will be used to retrieve all the data based on a seven digit employee ID number in order to edit or update the info. The other userform is to delete all record of the person. Sounds simple enough, but I cant figure it out (being new to VBA)

Any help is greatly appreciated.