+ Reply to Thread
Results 1 to 7 of 7

USERFORM -Trying to do Find all_button (Duplicates and edit individually)

  1. #1
    Registered User
    Join Date
    06-28-2014
    Location
    Bombay
    MS-Off Ver
    2007
    Posts
    33

    Exclamation USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    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
    Attached Files Attached Files
    Last edited by John Cruz; 07-23-2014 at 04:50 PM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    Try this out and see if we're headed in the right direction.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    06-28-2014
    Location
    Bombay
    MS-Off Ver
    2007
    Posts
    33

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    Thanks Tinbendr ...i really appreciate that extra you gave me "RECORD NUMBER" and the way it was designed.
    and also what i wished for was achieved in the first Reply from you it really helped me thanks again.

    But !!!
    When i try to add new or say when i press NEW button on "findedit Userform" it adds the record but it does not go in TABLE i made, but it goes below table leaving one row empty . can it corrected. thanks again

    Thanks again in Advance

    and one more thing HOW TO CLOSE POST?

  4. #4
    Registered User
    Join Date
    07-16-2014
    Location
    Washington
    MS-Off Ver
    2010
    Posts
    37

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    If your problem or question has been solved, you can edit the first post, go advanced and change the Prefix to SOLVED.

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    Here's a new version.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-28-2014
    Location
    Bombay
    MS-Off Ver
    2007
    Posts
    33

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    Hi Tinbendr

    The files Find&Edit UserForm looks and works great
    .
    Really appreciate .THANKS FOR YOUR HELP
    I have other issues also i will raise other post for that ...
    if i have uploaded new post for new issue, How can i ping you so that you can have a look on the issue ,
    any Tools in this forum like messaging or anything else.
    Have a Great Day
    John Cruz

  7. #7
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: USERFORM -Trying to do Find all_button (Duplicates and edit individually)

    You can always post a link in this thread to the other one since it is a continuation of the same project, but a different problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform Trying to Add Find & Edit button same like Excel Find All
    By John Cruz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 11:43 PM
  2. [SOLVED] Lookup/Search/Find/Match then edit in userform
    By Cuba64 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-17-2013, 06:49 PM
  3. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  4. USERFORM: EDIT to include FIND, DELETE & CLEAR
    By srands in forum Excel General
    Replies: 2
    Last Post: 01-03-2013, 01:15 AM
  5. Userform Search, Find and Edit Data
    By Chris270 in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 08-24-2011, 05:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1