+ Reply to Thread
Results 1 to 3 of 3

edit data in userform and update spreadsheet

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Port Macquarie, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    edit data in userform and update spreadsheet

    Good morning everyone,
    I am having a problem getting my code to work. I am trying to find a record in a userform, edit it and then save it back to the spreadsheet. I have successfully used a combobox to locate the individuals name and show their details, and a hidden textbox to store the ID number. The code that I have sourced and customised works for changes in the first field only. Any changes I make to any other fields does not show on the spreadsheet. Any comments on the code would be appreciated.

    Please Login or Register  to view this content.
    Cheers,
    Nunans
    Last edited by nunans; 03-08-2012 at 04:48 AM. Reason: SOLVED

  2. #2
    Registered User
    Join Date
    03-06-2012
    Location
    seattle, USA
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: edit data in userform and update spreadsheet

    Did you check how many times the for loop is executed?

    I can debug if you can upload the xls that you are working on.

  3. #3
    Registered User
    Join Date
    03-07-2012
    Location
    Port Macquarie, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: edit data in userform and update spreadsheet

    I actually ended up going with another piece of code.

    Please Login or Register  to view this content.
    Cheers,
    Nunans

+ 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