Results 1 to 9 of 9

Duplicate UserForm pasted info

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    72

    Duplicate UserForm pasted info

    When I 'Submit' my userform it places the textbox entries onto a separate sheet in the first available row as intended.

    What I also would like it to do is duplicate the entries if a specific field is filled out so it essentially fills in the first 2 available rows instead of just one.

    What I have is a textbox named txtNew that when filled will assign a new serial number to the product identified in the form. I need to put in all the userform's info in one row under the original serial number and repeat right away with the new serial also. This is so that when searching for either serial number the user will be able to pull up record of the change.
    Last edited by nohero; 06-27-2011 at 10:03 AM.

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