Needed: VBA code to edit/update data (sample workbook attached)

Right click on the EA - Coding Form tab, choose view code and paste the code into that window.
The code will run whenever you change the selection in the box. Check for accuracy because I just took the cells in your code where you pasted data into the data table and used them to put the data back. Then I restored your formulas with the total labels above them.

Good Luck!!!

Please Login or Register  to view this content.

Yeah, my question would be what do you mean by doesn't work? Is there a cell that has the wrong data, the code doesn't do anything?
You are enabling macros? If it's not doing anything, then type something in a cell and run your clear program, or better yet I'm sending the file back to you populated. I opened the spreadsheet and changed the box to 444 and you can see the results, so what's wrong with what it's doing? Hopefully it's not a MAC issue but if your clear code is working I don't think it is. Let me know.

Okay, please open this file and run the code by changing the drop down and pushing the button I put on the sheet.

Geez let me have some more coffee. I saw your request at the bottom and I was responding with if I can't get past this first problem how can I help you with the other. I read your first line as it is "not" working, but now that I see "now", well then yes maybe I can help you. I have one other test I would like you to perform.

Open the file below change the box to another number, don't push the button I just want you to change the box and if something happens let me know exactly what it was. Write down anything that comes up exactly as you see it.

I'd be more than happy to help you with the other thing.

I'm not finding anything on the internet. The change event doesn't seem to be firing, so I guess you 'll have to live with a button. I'll let you format that and put it where you want on the sheet.

So your request is if you recall data and change it, you want to overwrite the existing data on the other sheet, correct? Do you want to do this in all circumstances or do you want the option of creating a new record. If you want a new record I would recommend a way to have a different subject ID number than the first time, otherwise when you open the drop down list how would you know which one you want? You are going to see several and the previous code I wrote for you is going to pull up the first record with the number you choose.
I'll start writing the code, if you want to fix that button however you want and repost that sheet I'll just add it to that sheet. The code I put into the sheet I posted needs to be removed because I ran it on my computer and it will just keep looping if it starts to work on your computer. I had to hit control break to get it to stop.

Originally Posted by MileHigh_PhD

Hi skywriter,

I tried the revised file and do not see anything happening when I select a different StudyID from the dropdown in B2...

Test this by changing some recalled data and by adding a new record and make sure they all work.

My pleasure.