+ Reply to Thread
Results 1 to 8 of 8

Unable to import data to userform to edit. Also, autonumber(not formula).

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Unable to import data to userform to edit. Also, autonumber(not formula).

    After tweaking these two userforms and eliminating all unneccessary portions of code and userform, I've got a concise example of what I'm working with. The issues I'm having are with getting the data back into my userform for editing and creating an autonumber within the userform. The reason I can't use the formula version is because data will need to be sorted and the autonumber formula disregards sorting of any kind.

    As always, any help is greatly appreciated. At this point, any feedback on making the already existing code more efficient is also extremely welcomed!

    Thanks for taking a look guru's!

    Example Autonumber (Broken).xlsm
    -Orestees

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    Next day bump!

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    Maybe some code will entice people. Here's a bit of code I'm having issues with.

    Please Login or Register  to view this content.
    The purpose is to use the IDTag Combobox to repopulate the rest of the form for editing. The most important thing I'm missing is the code to search the rows based on the value selected in the combobox. I believe this code was in place at some point but it has been completely lost to me now.

    Any ideas?

  4. #4
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    Next week bump...
    Anyone?

    Buachailli, Cabhair liom!
    Last edited by Orestees; 09-24-2012 at 03:00 PM.

  5. #5
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    End of workday bump...

  6. #6
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    I also wanted to mention that editing the information should create a new ID for the update, not directly edit the existing info.

    Thanks to anyone who replies. Seem to have hit a dry spell with this thread.

  7. #7
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    Bump of despair. . .

  8. #8
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Unable to import data to userform to edit. Also, autonumber(not formula).

    Dead thread. Marking as solved just to move on.

+ 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