MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Drawing triangles using a form

  Asked By: Raynard    Date: Jan 03    Category: MS Office    Views: 1437

I have a form that ive designed with 3 input areas for a user, that is
the 3 sides of a triangle. I have a calculate and an exit button. There
is a check box if the user checks it then the largest side has to be on
the bottom of the triangle. My goal is to display this triangle on a
sheet. I have a button on a sheet saying 'show form' and the form shows
up. Then the user has to input values and click 'calculate'. Can anyone
help me? how do i draw a triangle using a form on a sheet.
How would i get the values entered by the user to display as lines on
the sheet forming a triangle.



2 Answers Found

Answer #1    Answered By: Lurline Fischer     Answered On: Jan 03

You calculate  the co-ordinates of each vertex and then apply those
co-ordinates to the vertices of a shape from the shapes collection.

If you get stuck tell us which bit you are having problems with, post the code
you have, and we will help you.

Answer #2    Answered By: Alfonsine Miller     Answered On: Jan 03

I know Andy Pope's website has information about drawing  on userforms. You can
download a self-contained demo worksheet from there using this link:


Then, maybe studying his code will help you.

Didn't find what you were looking for? Find more on Drawing triangles using a form Or get search suggestion and latest updates.