If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Manipulating shapes with VBA

Thread starter Worf
Start date Dec 22, 2019

Overview Discussion

Worf

Well-known Member

Dec 22, 2019

Worf submitted a new Excel article:

Manipulating shapes with VBA - This project shows how to create and modify shapes with code.

Here is a description of this application:

Canvas sheet - shows your current work.

Problem sheet - presents the original problem and also some examples that can be pasted on Dat page.

Dat sheet - There are stored triangles vertices generated by the program. Alternatively, you can insert your own data.

Do not leave any blank cells in the middle of your data range. Each line represents the three vertices of a triangle.

Be sure to start on the third row.

The x axis runs from left to...