Macro for pop up

[Srushbri1]

I am trying to create a button that pops up and gives 4 checkbox options. I would like each of those check marks to run a different macro, when selected.

Can Anyone help?

I want this button, macro called Module3:

To popup this called PublishShrinkagePopUp:

And then I want each one selected to run a different macro. Each macro can run one after another and combination doesn't impact another so, if "Week1 - O/U" is selected and "Week 2 - Full Shriankge.." is selected then I want it to run the first and fourth macro.

I don't know enough make this execute!

 

[DanteAmor]

In module3 put the following code:

Sub OpenForm()
  UserForm PublishShrinkagePopUp.Show
End Sub

I want this button, macro called Module3:

Assign the button to the OpenForm macro.

-----------------------
In the code of the PublishShrinkagePopUp form, put the following:

Private Sub CommandButton1_Click()
  If CheckBox1 Then Call macro1
  If CheckBox2 Then Call macro2
  If CheckBox3 Then Call macro3
  If CheckBox4 Then Call macro4
End Sub

 

[Srushbri1]

Thank you! That helped!

Can you tell me what I need to add so that after I click the "Publish Shrinkage" Button the PublishShrinkagePopUp box closes?

Thanks!

 

[Srushbri1]

In module3 put the following code:

Sub OpenForm()
  UserForm PublishShrinkagePopUp.Show
End Sub

Assign the button to the OpenForm macro.

-----------------------
In the code of the PublishShrinkagePopUp form, put the following:

Private Sub CommandButton1_Click()
  If CheckBox1 Then Call macro1
  If CheckBox2 Then Call macro2
  If CheckBox3 Then Call macro3
  If CheckBox4 Then Call macro4
End Sub

Thank you! That helped!

Can you tell me what I need to add so that after I click the "Publish Shrinkage" Button the PublishShrinkagePopUp box closes?

Thanks!

 

[DanteAmor]

Try Unload Me:

Private Sub CommandButton1_Click()
  If CheckBox1 Then Call macro1
  If CheckBox2 Then Call macro2
  If CheckBox3 Then Call macro3
  If CheckBox4 Then Call macro4
  Unload Me
End Sub