How to use graphics drawing library for Excel VBA

Settings for enabling use of VBA

To use VBA in Excel, it is necessary to show the "Development" menu and set the security level of macros. Please refer to the written materials and information on the web for the operations required.

Embedding Graphics library for Excel VBA using AddShape instructions

Copy the source program of graphics drawing library using AddShape instructions and paste to Module 2. You can also use an Excel file that has the Graphics library built-in.

Fill in Module 1 with your own program.

Settings for calling graphics drawing instructions from another Excel file

When calling graphics drawing instruction from another Excel file, it is necessary to set reference for each file. (In the Visual Basic Editor, select "Tool"- "Reference setting") Files to be referenced must be placed in a fixed folder.

You can also add graphics drawing instructions as Excel add-ins. Save an Excel file incorporating graphic libraryin in AddIn format and copy to AddIn directory, then select "Add in" from "Excel" menu and add it.