Collect User Input Using VBA Form and Record Inputs in Macro Button

Hi everyone!

I need to collect user inputs by using a form in Excel and store the user input in a macro button so that when I click on the button, the results will be displayed in the appropriate cells.

For now, I've designed the form and added a "Confirm" button to the form. The user inputs display in certain cells in the workbook when I click "Confirm". However, if I deleted the data from those cells and want to generate the same results again, I would have to go through the data input process again.

Is there a way to automatically record the user inputs as I enter them into the form and create a macro button that would regenerate the data in the appropriate cells on click?

Thanks for the help!