+ Reply to Thread
Results 1 to 3 of 3

Amend Database Via Userform

  1. #1
    Forum Contributor
    Join Date
    04-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    135

    Amend Database Via Userform

    Hi

    I have trouble updating my excel worksheet after amending some data using the userform.

    When I click on the cmbsearch button, all fields on the userforms are updated/populated with the correct data except for multipage3. Likewise, multipage3 is unable to transfer updated data to the worksheet.

    Kindly assist with the code:
    1) cmdSearch - Sheet1, Column P-W populating Userform, Multipage3, Frame3Apple & Frame4Orange
    2) cmdAmend - Userform, Multipage3, Frame3Apple & Frame4Orange populating back to Sheet1, Column P-W


    Thank you for the assistance.

    Regards
    Nancy
    Attached Files Attached Files
    Last edited by nancyching1711; 03-11-2018 at 09:17 AM.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Amend Database Via Userform

    For the Search Button

    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Amend Database Via Userform

    Too much to post.
    Put it all in example file.
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Combining my userform with a userform template - 'find' and 'amend' feature
    By excelconditional in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2017, 04:13 AM
  2. [SOLVED] Using a userform to amend a string of VBA Script
    By Steven8294 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2012, 04:38 PM
  3. Using excel to amend to a database daily.
    By jgray152 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 01-05-2010, 10:06 AM
  4. Amend and delete entries using userform
    By zebra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2009, 12:05 PM
  5. Retrieve and amend records from database
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-15-2008, 08:06 AM
  6. Amend a record in a database with a form.
    By Jwalker in forum Excel General
    Replies: 0
    Last Post: 09-23-2006, 05:16 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