Excel - Run Macro on Cell Change
Solved/Closed
ja6924
-
Apr 20, 2010 at 11:39 AM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Apr 20, 2010 at 12:37 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - 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.
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.
Related:
- Excel - Run Macro on Cell Change
- How to change date format in excel - Guide
- Change computer name cmd - Guide
- How to change author in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Change lg tv name - Guide
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Apr 20, 2010 at 12:37 PM
Apr 20, 2010 at 12:37 PM
Hello,
Try to use this macro and adapt it if you need :
Best regards
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
