I have a user form transferring data to a new line in a spreadsheet. It's something like as follows:
I have added a function to update existing data entries. when a user clicks on the active line, the data from the active line is put back into the user form, so that the user can change and update the data:Please Login or Register to view this content.
However, at the moment instead of updating the same record, my code is adding a whole new entry.Please Login or Register to view this content.
could anybody suggest a modification which makes it so that this function replaces the existing entry?
Linked: http://www.mrexcel.com/forum/excel-q...ml#post4176860
Bookmarks