View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAD JAD is offline
external usenet poster
 
Posts: 43
Default Cell Status Activates Macro

The following is a simplified logic statement that I am trying to write in
VB. If someone could interpret it and make it work in VB, I would appreciate
it. What I am trying to do is active/run a macro whenever a specified cell
shows a value of "x". Here is the incomplete statement:

Sub...........Activate_Deactivate
If cell A12="x" then
Activate Macro named Start_Up
If cell A12<"x" then
Activate Macro named Hide
End Sub