Hi,
I have created a userform. It has list boxes which are populated with the tables on my worksheet.
My goal is to modify the data on these tables using the userform. I would like to select multiple rows in one listbox and move them to another listbox with a button that updates the tables with the modifications. I would also like to insert new data into the table using the userform
I have managed to get a code for the delete button working which deletes selected rows from the listbox on the userform and in turn deletes the same rows from the table on my worksheet but have been unsuccessful in getting codes to work for the other buttons.
Any help would be greatly appreciated as I have been struggling with this for a while and I think it would take a real expert in coding to get this working.
I hope I have explained this clear enough and feel free to ask me more questions.
Thanks
I have created a userform. It has list boxes which are populated with the tables on my worksheet.
My goal is to modify the data on these tables using the userform. I would like to select multiple rows in one listbox and move them to another listbox with a button that updates the tables with the modifications. I would also like to insert new data into the table using the userform
I have managed to get a code for the delete button working which deletes selected rows from the listbox on the userform and in turn deletes the same rows from the table on my worksheet but have been unsuccessful in getting codes to work for the other buttons.
Any help would be greatly appreciated as I have been struggling with this for a while and I think it would take a real expert in coding to get this working.
I hope I have explained this clear enough and feel free to ask me more questions.
Thanks