I've created a macro which rotates a circle -15 degrees each time the macro is called. The code which does the rotation is...Selection.ShapeRange.IncrementRotation -15. I would like to be able to change the
-15 value by using a "scroll" button on my worksheet, rather than having to go inside the macro and change the value. Is this possible?
You can use a user defined function.
called from cell using formula. This assumes scrollbar is linked to cell G1 and the shape is called 'Oval 1'
Please Login or Register to view this content.
=udfROTATE_SHAPE(G1,"Oval 1")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks