Alasdair
07-17-2010, 05:42 PM
Wouldn't know what VBA was if it knocked down and killed me, lumbered with Openoffice at home, so, if at all possible, could you post an worksheet with the solution embedded? I am genuinely sorry, and will learn VBA, just not this weekend.
----------
Excel 2000; w2000p
---------
I'd like to draw a right-angled triangle, anchored [not changing position within the worksheet] on the right angle, which changes side length depending on cell values entered for two or three of [height, base, hypotenuse].
So, for values 120 and 20, in cells a1 and a2, need to produce a 120*20 pt triangle, area 1200sqpts.
I am aware of ways to do something similar using conditional formatting, but it's the triangle I need for a printed infographic.
I am also aware that you can resize a triangle manually/use charts. However, this is impractical given that the output is a diagram with a grid of 48 triangles, expected to alter fast depending on variables elsewhere in the spreadsheet, and charts need resizing anyway to preserve scale. Also, it would be great if it resized on cell exit, rather than having to press a button.
Many thanks for your time. Hoping have posted in right place, please say if not.
----------
Excel 2000; w2000p
---------
I'd like to draw a right-angled triangle, anchored [not changing position within the worksheet] on the right angle, which changes side length depending on cell values entered for two or three of [height, base, hypotenuse].
So, for values 120 and 20, in cells a1 and a2, need to produce a 120*20 pt triangle, area 1200sqpts.
I am aware of ways to do something similar using conditional formatting, but it's the triangle I need for a printed infographic.
I am also aware that you can resize a triangle manually/use charts. However, this is impractical given that the output is a diagram with a grid of 48 triangles, expected to alter fast depending on variables elsewhere in the spreadsheet, and charts need resizing anyway to preserve scale. Also, it would be great if it resized on cell exit, rather than having to press a button.
Many thanks for your time. Hoping have posted in right place, please say if not.