+ Reply to Thread
Results 1 to 4 of 4

Update Existing Records with Userforms

  1. #1
    Registered User
    Join Date
    08-24-2020
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 ProPlus
    Posts
    2

    Update Existing Records with Userforms

    Currently have a workbook that has two user forms. 1st form is used for data entry and has 15 fields (userform1). Once a user completes the form, he or she can click on the button "add data to table" and the inputted data is then pasted into a separate tab as a new record. The second user form contains a listbox that shows all existing data entries in a list (userform2). Ideally, I'd like to be able to select an existing record from the list, have the current data displayed in userform1, make changes and then update the existing record in the sheet where all data is being stored. I've seen lots of examples online but none involve selecting and updating records from a list box. In reality, it would be easy for a user to simply go to the tab where the existing record is stored and manually update but I'd like to be able to do it in a form in order to reduce the likelihood of erroneous entries or mistakes being made.

    First time posting on this forum so please let me know if I haven't clearly articulated my current challenge and thank you in advance to anyone who can help.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,313

    Re: Update Existing Records with Userforms

    Attached simple data entry form as your description utalising a listbox for data recall for editing/updating/deleting.
    torachan
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-24-2020
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 ProPlus
    Posts
    2

    Re: Update Existing Records with Userforms

    Awesome, thank you so much. Any tips for how to paste that into my own file and edit it to expand for additional columns? Thanks in advance for any help you can provide.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,313

    Re: Update Existing Records with Userforms

    See big yellow banner - how to upload workbook.
    It is easier to advise seeing the actual app.
    Its the structure that is most important - de-sensitise any private data - leave enough to give typical type of input.
    torachan.

+ 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. merging existing worksheets with same userforms
    By namy77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2017, 02:22 PM
  2. update existing code to copy and KEEP existing data
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-26-2016, 05:41 PM
  3. Replies: 2
    Last Post: 02-21-2015, 07:06 PM
  4. UserForms - Editing and Search Existing Data
    By freyasan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 03:38 PM
  5. Pulling records matching two criteria and inserting those records into an existing list
    By desertfx41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 02:00 PM
  6. [SOLVED] need to be able to update records with button click and delete records sample included
    By unreal11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 11:45 PM
  7. Update Existing Records
    By sujitshukla in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2010, 06:58 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