+ Reply to Thread
Results 1 to 3 of 3

Userform coding can find data but won't update it

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    Tucson, Arizona, USA
    MS-Off Ver
    Office 2010
    Posts
    105

    Userform coding can find data but won't update it

    I've been working on a userform that I can use to update information on my spreadsheet but have run into a stumbling block, it will find the information I'm looking for but it won't update it. I've got a seperate userform for entering the data into the spreadsheet and modified its the coding several times to get my search and update userform (different beast altogether now), but keep running into the same problem each time. I've included my file and the coding for the search and update below. I've only managed to learn enough VBA so far to work on this project, so I'm pretty sure I've missed something obvious here.

    ThermalTestv2.xlsm

    Please Login or Register  to view this content.
    Last edited by LoneWolf3574; 12-26-2012 at 12:33 AM. Reason: typos & wrong file

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Userform coding can find data but won't update it

    Hi, LoneWolf3574,

    maybe use this alternative for updating and build on it:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    Tucson, Arizona, USA
    MS-Off Ver
    Office 2010
    Posts
    105

    Re: Userform coding can find data but won't update it

    I gave the wrong offset for the cells, so that's corrected. Once again Holger, thank you, you're a god send to my learning experience.

+ 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