How to pass variables between sheet and standard modules?!?

[simurq]

I have a combo box "Select Object" under Sheet1 module linked to "DropButton Click" event. Now, depending on type of object selected in this combo box, I need to assign object parameters to variables in the main (standard) module which is NOT linked to Sheet1.

How can I link these two subs and most importantly pass variables between them?!?

Thank you!

 

[Firefly2012]

You could use Public variables defined in a standard module - see Chip Pearson's site for good info on variable scope:

Understanding Scope