+ Reply to Thread
Results 1 to 4 of 4

have code need user form to automatically update existing information

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    54

    have code need user form to automatically update existing information

    Hello All,

    I need a little help in the attached work book the user clicks on cell D6”LC6 and a user form appears the user fills out the form and click close to update the data is transfers to the work sheet and the user form is cleared. If the user wants to update that row he would click a separate command button that would pull up the existing data for that row.
    My question is can this be done automatically I have the code for the command button but would like to do this automatically when the user form is activated for that row.

    Thanks in Advance, Jeff


    Master File 013013.xlsm
    Last edited by Jeff up North; 01-31-2013 at 03:38 PM.

  2. #2
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: have code need user form to automatically update existing information

    Mr. Jeff

    Your sheet is protected . Unprotected attached sheet and upload it again

  3. #3
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: have code need user form to automatically update existing information

    A bit of a 'quick & dirty' solution, but add the following code to the master userform

    Please Login or Register  to view this content.
    If the form is opened for an existing work order the fields will be automatically populated
    If you like my contribution click the star icon!

  4. #4
    Registered User
    Join Date
    01-16-2013
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: have code need user form to automatically update existing information

    Thanks you both,

    OllieB, this works perfect thank you again, Jeff
    will marked solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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