Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
how can a user form be made that can find show and edit info for inventory | Excel Programming | |||
Creating a User Form to update a list | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |