Advice using a Userform to Update rows

**cldcp00** · 01-21-2014, 08:20 AM

I have a spreadsheet which uses a Userform to add new rows of data and it is working fine. Basically the row added is a work request which is view by the team and either accepted or rejected and agreed dates accepted.

What I would like advice on.
Is it possible for me to use the same form to update a row? This is how I envisage how it could work

The user selects the row to be updated and then initiate the Form which now has two new buttons Load and Update

The load button would load the selected rows data into the form enabling the user to change/update fields as required then the update button would update the row.

Is this feasible? Or is there a better way of doing it?

If anybody has any VBA code which I could amend to achieve the above, I would be most grateful

Regards

**6StringJazzer** · 01-21-2014, 09:46 AM

The answer is Yes, although you might want to consider a built-in feature of Excel to do this. Here is a tutorial on the Data Form for 2003.

**Sean Thomas** · 01-21-2014, 09:51 AM

Alternatively it would be better if you could upload a workbook with your userform and sample data of what you are doing. Its always easier to write code for a set example rather than guess.