Interface Programming for Excel VBA programs and others

About Excel VBAProgramInterface Programming

○ The Excel VBA program interface is related to its form. For macro loading, a new button or menu must be added. You can click these interface elements to complete the work;

○ For common worksheet programs, you can add required buttons, or directly add buttons, list boxes, and other interface elements to the worksheet. The event processing program is located in the corresponding worksheet of the VBA project;

○ After Office 2000 (VBA 6 ?) A mode-free form is added. Using a mode-free form, you can create a floating window similar to a tool window and interact with the worksheet while opening the window;

○ For changes to the office interface, you can write the relevant CodeFor macro loading, there are addininstall and addinuninstall events. A qualified program should restore the Office program interface to its original interface when exiting.

Miscellaneous

○ An Excel project (a file or a macro) can call other files or load macro processes, functions, and public classes by adding a reference to the reference; in this way, you can use existing macro or program modules in many programs, or conduct cooperative development in this way;

○ Excel built-in functions should be used whenever possible. For Excel built-in functions, they can be used through [application. function name], but custom functions can be used directly in worksheets;