Hello,

attached file with the following changes:

=> in multipage(1);page(7):

 

_ new search option - when you click on the textbox (TRNNumber1), an inputbox will appear, where the number should be inserted,

and then click on the search button

 

_ now this page has 2 listboxes - one with the "search" data and the other with the general list

 

_ I added two options to control the two list boxes, to remove the selected item from the list box (with "search" data)

can be by double click or with command button... to transfer / add data from the listbox (general list) to the listbox (with search data) can be done by drag & drop or command button

 

_ command button (OK) with new macro, will ask the user if he wants to continue, after confirmation will delete all rows with the textbox number (TRNNumber1), will retain the number of the first row that had the textbox number(TRNNumber1), and from that row number, you will insert a row for each item in the listbox (from the survey data) and insert new data for each row with the changes made... I don't know if that's how you wanted it

with this procedure the new data are inserted in the sequence of the sheet data, example: search for number 2 (which in the sheet is between number 1 and number 3), clicking on (OK) deletes all rows with number 2 , and insert the new data (with the number 2 as well) between the data of the number 1 and 3, regardless of the number of lines that will be added

 

NOTE: I didn't change or add the missing controls (text box; checkbox ...) that you want to add, but you have everything ready to follow your project

 

confirm if this is what you wanted?

Miguel,

That is exactly what I wanted!!!

Thank you so much for your ongoing support - I could not have done this without you!

 

Learned a lot about VBA and controls from you 🙂