Hello,I've been trying to learn to write Visual Basic for Excel. One question that my Power Programming Excel VBA book doesn't explain well is:In the VB Editor for Excel in the Project Explorer ...

Compile error in hidden module in Excel or Word occurs when the code is incompatible with the version or architecture of this application.

Right now it only works in a formular but i really need to be a function with input / output in a module so i can call it from the whole project.