find next and then update on Excel form - VBA

[lifeseeker1019]

Hi there,

I have an Excel form that allows users to input data. I'm currently testing out the find and update functionality, and I'm stuck. please see the attached

Basically, here is what happens:

1) user will find a patient name by putting in the second textbox.
2) excel will find only in the 2nd column of "sheet1" for the patient.
3) there will be multiple entries for the same guy. So, when multiple entries are found, users can keep on clicking the "find" button until the right -record is found. (i want all the other 4 textboxes to auto-populate what's in the worksheet for that guy.
4) when the right record is found, users will then modify the record then click on "update" to finish updating record.
5) the update button will update records in the worksheet(sheet1)

right now, the code does the find, but not findnext when multiple entries are expected.

Please Login or Register  to view this content.

any help is appreciated

[MarvinP]

Hi lifeseeker (hope you keep finding it_)

I think you just need a fndrng.Select added like below??

Please Login or Register  to view this content.

[lifeseeker1019]

thank you! it works!