Find Function in Userform

[diane virtucio]

Hi,

I am basically new to VBA and currently working on a userform. What I wanted to do is to have a search/find function wherein the user can find and update the data if needed.

I have tried using some codes from the web but I am getting Byref argument type mismatch error.

Please Login or Register  to view this content.

Thanks!

[diane virtucio]

Hi,

Thank you for your response. I have made the revisions...will this be fine?

Thanks!

[wator89]

On which command button macro you get an error? And what that macro should do?

[diane virtucio]

It's command button4. What it should do is search data and display it in the userform so the user can edit it and update the sheet where the file is being stored...

sorry i think my codes got mixed up and im stuck.

[diane virtucio]

I have attached the file. Thanks!