Pass variables from userform to module

**Bishonen** · 10-08-2012, 06:34 AM

Hi again,

last thred from me regarding userforms etc.

I have a quite complex (in my opinion) userform in a sheet. It contains checkboxes, textboxes and other form controls. I have a "go" button as well.

When the "go" button is activated, I would like to pass all the variables (the states of checkboxes etc.) to a module and execute the code within it.

As example: Let's say i have 3 checkboxes - depending on whether the user has ticked them or not, I would like to run a macro which would select either "A1", "A2", "A3" or any combination of those three.

How do I proceed here? I don't want to ask anyone to create me a working macro for my example. I'm merely looking for a easy way to pass the info of a userform to the module.

PS. I know I could bind the variables to a range in a worksheet, but I'd like to make it work in a more "sophisticated" way.

Thanks

**Kyle123** · 10-08-2012, 06:40 AM

Why not have the code in the userform rather than a module?

**Bishonen** · 10-08-2012, 07:18 AM

Thanks for your reply Kyle123!

That's another way to do it. I just wanted to keep the workbook clean - userforms in userforms, fancy code in modules. If there is no other (easy) way to pass the info to a module, then I'll stick to the userform.

**Kyle123** · 10-08-2012, 07:24 AM

Well you can pass variables in functions, or by having public variables, you can also call a module and refer to the form through it's object - there are drawbacks to each, all of which make things more complicated

You'd be better putting the code that the userform uses in the userform, it makes it much easier to follow when you come back to it in 6 months and have forgotten how it works

You won't have to search all over your workbook then just to follow your code and find out what something does

It's better practice to keep things self contained, use your modules for functions and subs that need to be called from more than one place.