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

I believe the following will work from your example:

Sub_Activate_Deactivate()
If range("A12")="x" then Call Start_Up
If range("A12")<"x" then Call Hide
End Sub



"JAD" wrote:

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