Userform command buttons, close on click

With a userform command button, you can use the code below to close the form.
But if I have multiple buttons, and if any are clicked, how do I close the form.

At the same time as closing I want to copy the character in the "Caption" field.

Please Login or Register  to view this content.

Untitled2.png

Hi create a new class module, call it CBtns & paste this into it

Formula:

Please Login or Register  to view this content.

Then in the userform Module

Please Login or Register  to view this content.

The line in red must be at the top of the module, before any code.

You cannot copy the caption as such, but you could declare a global variable and use

Please Login or Register  to view this content.

Hi thanks, I reposted at #3.

Glad you sorted it & thanks for the feedback