+ Reply to Thread
Results 1 to 3 of 3

Editing userform record

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    231

    Editing userform record

    Hello Everyone

    I have userform named “Operation” with
    1-Save button
    2-search button
    3-Edit button

    1-Save Button
    Copies the values in the different textboxes to sheet named “DT”, in a new row
    2- Search button
    When the search value entered to “Textsearch” box, pressing search button populates the record values to the different text boxes
    3-Update button
    I need to use it after using the search button to edit the record values and save it in the same row, what it makes now is adding new row not updating the existing row

    So my question now , what changes to the update button code is needed to update the existing row not adding new one


    Codes for save and update buttons are as follow

    Save Button Code

    Please Login or Register  to view this content.
    Update Button Code

    Please Login or Register  to view this content.

    Thanks for your support
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    231

    Re: Editing userform record

    Sorry for the yellow color (

  3. #3
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    231

    Re: Editing userform record

    any help with this

+ 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. Userform Edit Record and GoTo record Command Buttons
    By 139runner in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-30-2020, 12:54 AM
  2. USerform First Record& last record in the form for Updation
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-09-2015, 10:19 AM
  3. Can't record a macro pasting and editing into a word doc
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2013, 11:46 AM
  4. Add new record to excel userform below the last record
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-27-2013, 02:49 AM
  5. Record type of cell editing
    By patact in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2009, 11:23 AM
  6. Update A Record In Access. Not Adding But Editing
    By internacio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2006, 11:40 AM
  7. [SOLVED] how do i record total editing time?
    By Jane in forum Excel General
    Replies: 1
    Last Post: 07-15-2005, 07:05 AM

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