Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Ive 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; Ive 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?

Reply With Quote

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 10:09 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. is not affiliated with Microsoft