References to external components

You can reference external components, such as ActiveX controls, from within your VBA project. When you distribute the VBA customization to other workstations, be sure that any additional components you have used are also installed.

To avoid problems referencing external components from your VBA project, do the following:

• Refer only to components you need. Don’t make references to components that aren’t being used in your project.
• Watch for “hidden” references, such as those created when you add a control to the Visual Basic toolbox.
• Be sure you have installed and registered needed components before running the VBA project.
• Keep external components in known locations, such as next to the VBA project or in the Windows “system” directory.

Documentation Feedback

---