Update a row in a different spreadsheet using VBA userform

Hello,

I am brand new to this forum and VBA.

I have recently created two forms in my workbook:

1. one to add in a new customer to the end of the data - this one works and is good for what I need (green button in my attachment)
2. one that allows me to search data, based on school name, and display information that is contained in the worksheet - works but I would like to add an update button (red button in my attachment)

In the user form that searches the data (red button) I would like to be able to change any of the required fields - press an 'update' button - and the data would be replaced in the relevant cell in the "Data" sheet (based on the school name - this is unique in each row).

I have been searching for a few days and tried various ways to get it to work; although as I am new to this I don't understand where I am going wrong and have not been able to find a solution.

I would greatly appreciate if someone had an answer to my problem (I just need the code to make it work if possible); even if it is that it can't be done - at least I can stop looking!

I have attached what I have so far.

Thanks in advance for any help.

Originally Posted by rorya

I don't really understand the code in your updateButton routine (ignoring the fact that you don't actually have a button by that name). It tries to populate the Data sheet with the values of controls in the other form, which presumably isn't loaded at that point, so they will all be blank.

Hi rorya,

Thanks for the reply. As I am brand new to this I really messed up what I was doing and thought it would be a variant on the code that worked for me in the other form .

I thought I deleted everything as it was not working; including the button!

Thanks

Originally Posted by Mumps1

Try the attached file. I have added an "Update Data" button to the Customer Order Tracking userform. First search for the school, change the desired data and click the "Update Data" button.

OMG you're amazing!

It looks so logical once you see it. Thank you so much for you quick response and fixing it - exactly what I needed.

I love it

Originally Posted by Mumps1

You are very welcome.

It works beautifully and i have been using loads over the last couple of days with no problems or errors.

You're a saviour, thank you.