hi,
i have attached a small workbook with my simple (?) question.
I have a function, where i can let any shape rotate in my workbook, but when you look into it You can see, that i want to anchor (... maybe wrong word)
the arrow to the circle.... is there a possibillity to do this easy?
Function ShapeRot(ShapeName, Rot)
With ActiveSheet.Shapes(ShapeName)
.Rotation = Rot
End With
End Function
stefan
anchor Arrow
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
anchor Arrow
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: anchor Arrow
Have you tried grouping the arrow and the circle? You can then apply ShapeRot to the group.
If that is not what you want. please try to explain more clearly what you want to accomplish. Your workbook doesn't provide any clues.
If that is not what you want. please try to explain more clearly what you want to accomplish. Your workbook doesn't provide any clues.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
Re: anchor Arrow
Hi Hans,
no, i don´t want to group the shapes, The origianl Idea behind it was to use this arrow as a gauge indicator and Windrose...
thats the idea behind it. The arrowfunction does what i want instead of leaving its base in one center point.
no, i don´t want to group the shapes, The origianl Idea behind it was to use this arrow as a gauge indicator and Windrose...
thats the idea behind it. The arrowfunction does what i want instead of leaving its base in one center point.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: anchor Arrow
Excel is a spreadsheet program with limited graphics capabilities, not a vector drawing program.
What you want is very difficult, if not impossible in Excel.
What you want is very difficult, if not impossible in Excel.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
Re: anchor Arrow
of course steve!
I only wanted to know, if this could be possible by a graphical function. So You can attach shapes very well.
I only wanted to know, if this could be possible by a graphical function. So You can attach shapes very well.
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: anchor Arrow
While the answer is that it probably can be done, the work involved can be complicated. It involves trying to figure out where the arrow will be as it rotates and then define the setup. Using the chart seems to be a much simpler method as it lets XL do the brunt of the work...
Steve
Steve