UserForm Search Button to find original records?

**matrixpom** · 10-17-2012, 06:02 PM

Good day all,

I have a UserForm on my first sheet ("Start") that populates data on a separate sheet ("Form"), I have allocated a "Find & Edit Original" cmdButton but the code I have found & tried to adapt doesn't seem to be working, the unprotect password "000" if needed, thank you all once again for your assistance, immensely appreciated, have a great day - Marco

**mike7952** · 10-17-2012, 06:51 PM

Give this a try

Please Login or Register  to view this content.

**matrixpom** · 10-17-2012, 09:26 PM

Hi Mike,

Your code works perfectly as always but is there a way to Re-populate the userform with the original data found so alterations can be made before reprocessing? Thanks again Mike - Marco

**mike7952** · 10-17-2012, 10:41 PM

Are you meaning instead of coping the found SWMS Reference to SWMS Sheet, just add the values to the form?

**matrixpom** · 10-18-2012, 12:09 AM

Hi Mike,

As well as really, the code you made is perfect but there may be occasions when the SWMS need to be revised, change of contractor or safe work procedure, so if it can also re-populate the userform the revisions can be made & then reprocessed, hopefully that makes sense? Thanks Mike - Marco