SOLVED

one my friend need help his file

Contributor

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

 

7 Replies

@sf49ers164480 

See the attached version.

@Hans Vogelaar 

 

Screenshot 2021-11-21 101017.jpgScreenshot 2021-11-21 101124.jpg

I got error after I put Tony and today date

@sf49ers164480 

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.

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
best response confirmed by sf49ers164480 (Contributor)
Solution

@sf49ers164480 

See the attached version.

how i do highlight row when i do search

@sf49ers164480 

New version attached.