Userform: Can you capture the selections from command buttons and call macros on close

Good Morning,

I have a userform that has several command buttons, the trouble is I have set the buttons to call the macros once clicked. However in real life people make mistakes and I imagine some people would want to change the button they click after clicking another.

The question I am asking is the following:

Is there a way on a userform to capture the selections people make and then call them when the final button is clicked? That way even if they change their mind the selections will not return an error?

Thanks in advance.

Darren

Hi,

You might store the pattern of clicks onto a sheet and display it on the form and allow the user to decide an auto click or a manual click option.

It would also be required to build a case function to call the relevant command.click function in the code.

Happy Computing.