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
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