ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Triangles in Basic Shapes (https://www.excelbanter.com/new-users-excel/140807-triangles-basic-shapes.html)

Felix

Triangles in Basic Shapes
 
With Basic Shapes (Triangle) I can draw all types of triangles, except obtuse
ones... Why is that?
--
Felix

Gary''s Student

Triangles in Basic Shapes
 
Hi Felix:

From the Basic Shapes grab the isosceles triangle and put it on your sheet.

Click on the triangle. You can then stretch it out into an obtuse form by
grasping a grab point and dragging.

Have fun !
--
Gary''s Student - gsnu200718


"Felix" wrote:

With Basic Shapes (Triangle) I can draw all types of triangles, except obtuse
ones... Why is that?
--
Felix


Felix

Triangles in Basic Shapes
 
This is what I tried, but if move the yellow grab poit I can only streck it
as far as a rightangled triangle
--
Felix


"Gary''s Student" wrote:

Hi Felix:

From the Basic Shapes grab the isosceles triangle and put it on your sheet.

Click on the triangle. You can then stretch it out into an obtuse form by
grasping a grab point and dragging.

Have fun !
--
Gary''s Student - gsnu200718


"Felix" wrote:

With Basic Shapes (Triangle) I can draw all types of triangles, except obtuse
ones... Why is that?
--
Felix


Gary''s Student

Triangles in Basic Shapes
 
Hi Felix:

Here is a macro that will make it automatically:


Sub Macro1()
Range("G11").Select
With ActiveSheet
..Shapes.AddShape(msoShapeIsoscelesTriangle, 267.75, 234.75, 87#, 88.5).Select
..Shapes(1).Select
End With
Selection.ShapeRange.ScaleWidth 4.09, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.97, msoFalse, msoScaleFromTopLeft
Range("G12").Select
End Sub


Open a new spreadsheet, install the macro and run it.
--
Gary''s Student - gsnu200718


"Felix" wrote:

This is what I tried, but if move the yellow grab poit I can only streck it
as far as a rightangled triangle
--
Felix


"Gary''s Student" wrote:

Hi Felix:

From the Basic Shapes grab the isosceles triangle and put it on your sheet.

Click on the triangle. You can then stretch it out into an obtuse form by
grasping a grab point and dragging.

Have fun !
--
Gary''s Student - gsnu200718


"Felix" wrote:

With Basic Shapes (Triangle) I can draw all types of triangles, except obtuse
ones... Why is that?
--
Felix



All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com