Excel VBA programming to draw a house on a form

Source: Internet
Author: User

Excel VBA programming to draw a house on a form . This tutorial is to introduce you to use Excel VBA programming on the form to draw a house method, the tutorial comparison basis, produced the effect is very good, recommend to see.

Steps

Open the Excel table and enter the VBE window.

Insert the module.

Programming in Module 1, declaring 4 functions, a structure, and writing a program that displays a form--"painting."

Insert the form.

This is the inserted form.

Double-click the form to enter the programming interface, write a form Click event-triggered program, and invoke the 1 structure-written programs declared in Module 1. This is the coordinates of the 4 points in front of the roof and the house, the coordinates of the 5 points on the side of the house.

This is the coordinates of 4 points between the door and the window.

Call the 4 functions declared in Module 1 to write a drawing house program.

Close the VBE window and start the macro in the Excel table interface.

Execute the macro--"draw".

The form appears on the table, which is the result of the "draw" program.

Click the form and a house appears, which is the result of the form click event Program.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.