+ Reply to Thread
Results 1 to 3 of 3

Search/update/delete records in userform

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

    Search/update/delete records in userform

    Hello Everyone

    So i am new to VBA world and i created a userform, i managed to make the form and a code to insert the data into a table "Save button" (code below)


    Please Login or Register  to view this content.

    what i need now is to make codes to find a record by searching with "WO#" and displaying the record data to update or delete it "Update and delete" buttons.
    could you please help me, i am sorry if it sounds stupid but i tried to google it with no luck
    File attached

    update.jpg
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Search/update/delete records in userform

    .
    Hopefully you can apply the code example from the attached project .. to your workbook :

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Search/update/delete records in userform

    Hi Logit
    I am lost :D
    i am new to the VBA world

    Could you please highlight the parts that need to be customized to my sheet when pasting the code

    Thanks Alot
    Last edited by Mahmoudelnemr; 06-13-2019 at 09:28 AM. Reason: Typos

+ 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] Delete/Update/Add/Search records in userform
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-15-2016, 04:20 PM
  2. Excel UserForm to browse, update, add and delete records in Access
    By takriv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2016, 11:15 AM
  3. On Userform, how to put Search, Delete, Add, Update buttons
    By TSHEPO19811 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-07-2015, 10:38 AM
  4. [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
  5. Search records from userform and update data list
    By craigw27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2013, 08:55 AM
  6. Search and Update records in database
    By Manoqs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2012, 04:25 AM
  7. Update records via UserForm
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2011, 04:04 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