Userform close (without button)

[Pestomania]

Hello,

Is there a way to close the userform from within my VBA code without selecting a button. I want this to happen without human interaction.

Thank you

 

[Fluff]

When would you want it to close?

 

[Pestomania]

When would you want it to close?

The userform has 4 options. When one of those options are selected, the userform should close and go through with the selected macro.

 

[Fluff]

In that case just put

Unload Me

As the last line in the relevant code.

 

[Pestomania]

In that case just put

Unload Me

As the last line in the relevant code.

Hi I keep putting that in different ways that I can think but it keeps staring that it is an invalid use of the keyword.

 

[Pestomania]

I have also used the Unload Userform1 command. Doesn't work.

 

[Fluff]

What code do you have for the option buttons?