Hi friends
Need your Help with the codes
I have attached file plz take a look
USERFORM --find button
Trying to do Find all (Duplicates and edit individually --update it their itself or place it in
new row)
What i am trying to acheive is Find with "ticket no"
RoadMap of project for you all (just idea)
=====================================
0) user clicks "START" on worksheet --->goes to Userform "Production"---> clicks "Find & Edit"
button on userform.
next he is taken to FindEdit userform after that
1)User want to find a "Ticket no" (Their can be "Duplicate no" as these tickets are worked
again an again due to some issues )
2)To find he will put it in "textbox" in front of "Ticket no"
3)in Return He will get 4 to 5 same ticket no (depends how many time he have worked on Same
ticket) ....for this reason i want this to come in ListBox right at bottom on find userform
4) when the list is generated he clicks in one of the ticket no in listbox , which will auto
populate other fields.
5) if he want to edit/add Extra Notes of the found ticket and want it to be on same row then he
just have to click "Update button".
and if
6) he want to edit but dont want to keep on the same row He will click on new
Thanks in advance
Bookmarks