Hey folks,

I have a list of 150 statements in an excel sheet. The 150 statements are in cells A1 to A150. Cells B1 to B150 are cells that should contain the answers to the corresponding questions.

I would like to create a userform that displays the questions and allows the user to write in an answer into a textbox that can then be saved to the excel sheet. i would like to use spin buttons to allow the user to move to the next question, and also to move back to previous questions and edit and save their answers to the questions.

I have tried to look for code online however after atempting i cant seem to get it working.

I understand this may sound cheeky, however i would be extrememly grateful if anybody could provide me with a solution, and if possible some code to use.

Thanks in advance

Kind regards,

wetfish