Hi,

I thought this was a standard question but I can't find it anywhere. Anyway.

withing a Worksheet_SelectionChange routine I need to either:

-access a global variable declared within a standard module (error message: Compile error: only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions) OR

-run a public function and a sub declared within a standard module (error message: "internal error")

Any clue how to do this?

Thanks in advance!!

(an answer to do both would obviously also be great)