Hi guys!

Hopefully a nice easy one for you.

I am creating a data entry user form and I need help with the edit button.

This button should edit the row on the worksheet from which the the user form is displaying the data. eg If row2 is displayed then only row2 should be repopulated when the edit button is pressed. If row 10 then row 10 etc. etc.

I can scroll through the data using next and previous and I can add new line at the first free line but I don't know how to code the edit button.

As I understand it need to be able save the row number and load into a global variable and then this will help tell the edit button where to send the data. Some guidance in laymans terms would be much appreciated as I'm far from expert!!!!!

See attached (there are still a few minor bugs to sort and if you run the form with out selecting frm the IDStore, Ebay Category and Amazon SubCategory combo box it will crash when using the add new line button but I can fix this!) Data Entry NEW.xlsm