![]() |
#1
|
|||
|
|||
![]()
I have a simple test and calculation.
Two variables: * A2: Ship direction =rand()*360) * B2: Wind direction =rand()*360) One calculation: * C2: Apparent wind direction (relative to the ship) =B2-A2+IF(A2>B2,360,0) One button activating a macro that recalculates the ship and wind directions. Pretty simple, but I'd like to fancy it up. I've put in three arrow shapes, one each for the ship, wind, and apparent directions. I'd like the macro to change the rotation of these based on the recalculated results. I'm so rusty in VBA. Any help would be appreciated. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
preetidb | PowerPoint | 4 | 12-30-2013 03:22 PM |
color change for same shape | ajkiran | PowerPoint | 1 | 11-10-2012 07:41 AM |
![]() |
excelledsoftware | PowerPoint | 3 | 03-01-2012 06:59 PM |
![]() |
shinyjellicent12321 | PowerPoint | 1 | 02-19-2012 11:43 AM |
Motion Paths with Rotation | PBone | PowerPoint | 4 | 01-13-2011 11:59 AM |