+ Reply to Thread
Results 1 to 2 of 2

userform - lookup and write data to a specific row in a worksheet

  1. #1
    Registered User
    Join Date
    London, UK
    MS-Off Ver
    Excel 2010

    userform - lookup and write data to a specific row in a worksheet

    I'm stuck!

    The question(s) is:
    1. How do I get a userform to write data to a specific worksheet row (this row will be identified by the content of the first cell in the row)?
    2. How do I populate the content of a userform with data from a worksheet (located by entering the uniqueID) and then allow users to edit it and write the data to the corresponding row on the worksheet?

    I’ve created a multipage userform, with the option to submit data at the bottom of each page.
    The first page allows users to enter basic data with a command button (code below), and the subsequent pages will allow users to enter further information to the same record (appearing on the same row in the worksheet)
    On clicking submit on the first page, a uniqueID is created for this record and this id along with the rest of the data on this page is written to a worksheet

    What I’m having trouble doing is writing data to the same worksheet row at a later stage in the multipage userform, and looking up the data at a later date and enable editing

    The code for the first page of the userform Submit Command button is below:

    Please Login or Register  to view this content.
    The second page in the userform is MultiPage1 and this also has text and combo boxes on it, and when users input data into these boxes I need it to appear on the same row as specified by the uniqueID (tboSetupUniqueID.Value)

    Hope someone can help


    Last edited by Cutter; 09-03-2012 at 02:01 PM. Reason: Added code tags

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    MS-Off Ver
    Excel 2010

    Re: userform - lookup and write data to a specific row in a worksheet

    @ EMAP

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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