Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

LinkBack Thread Tools Display Modes
Old 10-04-2007, 07:31 AM
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
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

All times are GMT -7. The time now is 04:42 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft