Excel - Run Macro on Cell Change

December 2016




Issue


I am trying to have 1 of 8 different macro's run depending on the value of a specific cell.
  • If I enter 1 in cell A3, I would like macro1 to run. If I change cell A3 to 2, I would like macro2 to run and so on all the way up to entering 8 and getting macro8 to run. I am unable to find any good examples of how to do this.
  • Is there any way to use a formula to get this accomplished? If not what is the macro code I will need.

Solution


Try to use this macro and adapt it if you need :

Private Sub Worksheet_Change(ByVal Target As Range)  
    If [A3] = 1 Then  
    Call Macro1  
    End If  
      
    If [A3] = 2 Then  
    Call Macro2  
    End If  
      
    If [A3] = 3 Then  
    Call Macro3  
    End If  
      
    If [A3] = 4 Then  
    Call Macro4  
    End If  
      
    If [A3] = 5 Then  
    Call Macro5  
    End If  
      
    If [A3] = 6 Then  
    Call Macro6  
    End If  
      
    If [A3] = 7 Then  
    Call Macro7  
    End If  
      
    If [A3] = 8 Then  
    Call Macro8  
    End If  
      
End Sub

Note that


Thanks to venkat1926 for this tip on the forum.

Related :

This document entitled « Excel - Run Macro on Cell Change » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.