Find and Update with User Form
 

I have a multipage user form to enter data to sheet1. When portions o
the customer record need to be edited or information added, I want t
be able to update the excel sheet1 using the same user form that wa
used to enter it in the first place.

I have added a "FIND" button to do the following. Unfortunately i
doesn't work...

1. enter serial number into "FIND" textbox
2. search sheet1 by serial number
3. If found, load appropriate row contents of sheet1 into user form fo
editing.
4. User to update fields that require updating.
5. Press OK button to save new information to original row on sheet1.
5. If not found, error message " not found".

My code is attached.

Thanks much

Attachment filename: rma log test.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=54815
--
Message posted from http://www.ExcelForum.com