Excel - Run Macro on Cell Change [Solved/Closed]

Question

Excel - Run Macro on Cell Change [Solved/Closed]

Report

ja6924 - Apr 20, 2010 at 11:39 AM
aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

- Apr 20, 2010 at 12:37 PM

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.

Excel - Run Macro on Cell Change
Excel - Run Macro on Cell Change - How-To - Excel
Excel execute macro on cell change - How-To - Excel
Blinking cell in excel without macro ✓ - Forum - Excel
Excel - A Macro to copy and paste data in next blank cell - How-To - Excel
Excel - A Macro to insert data in specific cells - How-To - Excel

1 reply

Ask a question

aquarelle · Answer 1 · 2010-04-20T12:37:40-0400

Hello,

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

Best regards

Excel - Run Macro on Cell Change [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!