use Excel VBA programming to draw a hexagon on a form. This tutorial is to share with friends the use of Excel VBA programming on the form to draw a hexagonal method, the tutorial is very good, suitable for beginners to learn, recommend you to see it.
Step 1
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, resized as shown.
Double-click the form to enter the programming interface, write the form click event-triggered program, invoke module 1 declared 4 functions, a structure to write programs.
Close the VBE window and start the macro in the Excel table interface.
Executes the macro.
The form appears on the table, which is the result of the "draw" program.
Click the form, and a hexagon appears, which is the result of the form click event Program.