Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

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

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 10:24 AM
Correct "Invalid character Setting" in word docume diamond1vn Word 0 02-16-2008 05:46 AM
How 2 retain MSOffice "Upgraded" on full restore misterbobthetomato Office 0 02-04-2007 01:08 PM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 04:23 AM
Outlook Today's "Inbox" and Showing New Mail for E my02wg Outlook 0 03-19-2006 08:36 AM


All times are GMT -4. The time now is 04:12 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.