PDA

View Full Version : Edit/Delete Data Row



BigPaulyMc
11-16-2015, 05:34 PM
I have a user form that fills in a row of a spreadsheet. Each new user form entry is added to the next empty row. In the first column of each row I have a "line item number "that populates with each new data entry. Is there a method of making that a hyper link that would open a user form that would open, pre-populated, with that rows data? I would then have buttons on that userror form: Edit: which would allow me to over write the data of this particular row with whatever information I changed in this form. Delete: which would delete this particular row from the spreadsheet and move all the rows below it up, and a Cancel button that would just close the form. I know very little about vba....please be gentle