+ Reply to Thread
Results 1 to 1 of 1

Capturing data from a userform to a worksheet

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Des Moines, Iowa
    MS-Off Ver
    Excel 2007
    Posts
    18

    Question Capturing data from a userform to a worksheet

    I have a macro that is starting to get pretty intensive and beyond my knowledge base. Currently is takes the needed data from sheet(1) and copies it to a newly created "Sheet2" in a specific format. Once the macro is done formatting "Sheet2", it shows both userforms for the next part of this macro.

    One userform (UserForm1) is for inputting barcode data into rows on "Sheet2" (this is where I am running into problems). I cannot get the userform to capture the captions to the needed cells in "Sheet2".

    The other userform (UserForm2) is for a visual representation of the error check. This will check for differences in Sheet2's column data. If a row's data in Sheet2 doesn't duplicate as expected it will flag RED and an image to show in the associated frame in UseForm2.

    UserForm1:
    Plate ID (PlateIDLabel goes to "PCR Plate ID" header column in Sheet2)
    Plate Location (PlateLocationLabel goes to "PCRLocation" header column in Sheet2)

    Currently the userform is coded to recognize prefixes for correct input into label textboxes.

    Attached it the workbook with macro/userforms.

    Please Login or Register  to view this content.
    Any assistance would be much appreciated.

    Thanks for looking!

    J.
    Last edited by goldbeje; 08-29-2012 at 07:54 PM.

+ 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

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