one my friend need help his file

[sf49ers19238597]

He need with submit button on top half. to submit form to worksheet. he want simple code that he can configure out.

Bottom half is for search info have button for search, he had update button just case he change any info, He also have clear button clear search area. He we simple cod for both selection

Thanks You

[#2]

@sf49ers19238597 

See the attached version.

[#3]

@Hans Vogelaar 

I got error after I put Tony and today date

[#4]

@sf49ers19238597 

That is not a problem of the code, but of your formula in the Days Remain column: it fails if today is the person's birth date.

I have change the formula for age and birth date and now it works OK.

[#5]

my added a remove button he want button clear textboxes and remove row where data is location data removed data from worksheet go back to normal

Thanks you

[#6 · Accepted solution]

@sf49ers19238597 

See the attached version.

[#7]

how i do highlight row when i do search

[#8]

@sf49ers19238597 

New version attached.