Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2007, 07:31 AM
mfgeng_iss mfgeng_iss is offline
Novice
"IF" "THEN" statements in Macros
 
Join Date: Oct 2007
Posts: 1
mfgeng_iss
Default "IF" "THEN" statements in Macros

I’ve created a Fluid Schematic diagram and am currently automating it in order to visually track valve positions (open/closed) and what systems are pressurized. Using the record macro option; I’ve associate two buttons for each valve, one open(green #3) the other close(red #2). Upon double clicking the open button [shapes.item(6)] for Valve “A” the open button turns green, the close button turns white and lines 1,2,3 change from black (indicating no pressure) to purple (indicating pressure). I want to add this condition: If Valve “B” is open “Then” change lines 4 and 5 to purple. Note: Valve “B” is open when shapes.item(7)=”3”. Can you help?

Thanks
Dave
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"IF" "THEN" statements in Macros MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM
How 2 retain MSOffice "Upgraded" on full restore misterbobthetomato Office 0 02-04-2007 11:08 AM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM
Outlook Today's "Inbox" and Showing New Mail for E my02wg Outlook 0 03-19-2006 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 PM.


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