View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Danny Chan Danny Chan is offline
external usenet poster
 
Posts: 1
Default Excel VBA drawing Arcs programmatically - not lining up!

Hi guys,

I am working on a visual display (speedo dial) in Excel similar to what
you have been talking about in this thread.

I can assist with the issue that has plagued me (moving arcs).

It is an artefact of the drawing of the arc that causes it to move... as
has been discussed earlier in the thread.

So I figured if it is drawing an arc then why not try to pin it in the
one place that should stay in one spot - the centre. This can be found
and referred back to the .top and .left placement points using .width
and .height. This should work for all quadrants of the arc.

I have only tried it successfully on the dials in my project but feel
free to feed back to me and I can see if I can help if you can't get it
going.

NeoDan

*** Sent via Developersdex http://www.developersdex.com ***