VBA for search function is not working

[Saravanan_rajendran]

Hi All,

I am new to excel vba and need to fix an issue for searching data from the database. I need to search for an ID which is in C column of Database sheet and get the values visible in all the respective fields in form. I tried to my level best but couldn't fix. Attached the excel sheet for your reference. Kindly advise.

Thanks all.

With Regards,
Saravanan R

[Bernie Deitrick]

Use the Match function like so:

Please Login or Register  to view this content.

[nankw83]

Hi Saravanan & welcome to the forum

Try below code ...

Please Login or Register  to view this content.

Edit: Just noticed that your data in "form" sheet is in the same order of "database" sheet so below code works without loops ...

Please Login or Register  to view this content.