Assign macro to user form checkbox without running it

[PaulM100]

I've created a userform containing multiple checkboxes and I want to assign a macro to each checkbox without running the macro when the checkbox is checked. Ideally, each macro is assigned, you select all the checkboxes planned to run, and afterwards you run all the macros, based on a userform button. Currently it looks like bellow.
Anyone may have some hints on how to make this possible?

[romperstomper]

That doesn't really make any sense to me. It sounds like what you want is one piece of code that does various things based on what checkboxes are checked, not routines 'assigned' to checkboxes per se.

[ptmuldoon]

Checking an individual box will not run the macro for you automatically.

You can create your scripts for each checkbox. And then with a command button, when that is pressed, check if the box is checked and run a particular macro.

can you post a sample file with with the userform?

[PaulM100]

That's correct rorya, had a moment of stupidity. Something like this probably will work, right?

If CheckBox1.Value = True Then Call BFS
If CheckBox2.Value = True Then Call BHX
If CheckBox3.Value = True Then Call BRS
If CheckBox4.Value = True Then Call CWL
If CheckBox5.Value = True Then Call DUB
If CheckBox6.Value = True Then Call EDI
If CheckBox7.Value = True Then Call GLA
If CheckBox8.Value = True Then Call LBA
If CheckBox9.Value = True Then Call LCY
If CheckBox10.Value = True Then Call LGW
If CheckBox11.Value = True Then Call LHR
If CheckBox12.Value = True Then Call LPL
If CheckBox13.Value = True Then Call LUT
If CheckBox14.Value = True Then Call MAN
If CheckBox15.Value = True Then Call NCL
If CheckBox16.Value = True Then Call PIK
If CheckBox17.Value = True Then Call STN
If CheckBox18.Value = True Then Call CGI

Is there a way to make it shorter?

[romperstomper]

You could remove all the Call keywords.

Do the routines do similar things? If so, you could have one routine that takes an argument and alters accordingly. If not, you could assign the name of the relevant macro to the Tag property of each control and then use a loop like:

dim i as long
for i = 1 to 18
If Me.Controls("CheckBox" & i).Value = True Then Application.Run Me.Controls("CheckBox" & i).Tag
Next i

which is roughly analagous to your original intention of "assigning" a macro? It does assume the routines are all in a normal module.

[PaulM100]

Do the routines do similar things? If so, you could have one routine that takes an argument and alters accordingly

Unfortunately, all are doing different things. And honestly, this is the first time that I used a userform. I wasn't really interested in them until now. I did what you suggested and this fixed my issue. Thank you for your help!