Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-05-2014, 09:29 AM
gebobs gebobs is offline VBA to change shape rotation Windows 7 64bit VBA to change shape rotation Office 2010 64bit
Expert
VBA to change shape rotation
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default VBA to change shape rotation

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.
Attached Files
File Type: xlsm RWD.xlsm (16.2 KB, 19 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to change shape rotation Change accent theme color used as shape fill (not RGBs) preetidb PowerPoint 4 12-30-2013 03:22 PM
color change for same shape ajkiran PowerPoint 1 11-10-2012 07:41 AM
VBA to change shape rotation enter free rotation excelledsoftware PowerPoint 3 03-01-2012 06:59 PM
VBA to change shape rotation Rotation Animation? shinyjellicent12321 PowerPoint 1 02-19-2012 11:43 AM
Motion Paths with Rotation PBone PowerPoint 4 01-13-2011 11:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft