Interface Programming for Excel VBA programs and others

Source: Internet
Author: User
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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.