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



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 09:15 AM.


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