#1
|
|||
|
|||
"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 |
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 |