'Loop through Cells C3:C33 to get this code to run continuously so I can run a macro when I input into any of these cells?
So I want to run a macro when I select something from a drop down list in each of the cells C3:C33. I have gotten thus far with the code and it works for just one cell (C3 as shown below). I can't figure out how to continuously loop form C3 to C33 so that my Macro will run when I change any of those cells.
Private Sub Worksheet_Change(ByVal Target As Range)
myCell = "C3"
If Not Intersect(Target, Range(myCell)) Is Nothing Then
Select Case Range(myCell)
Case "IB-16": Input_Open
Case "OB-16": Output_Open
Case "IF-8": AI_Open
Case "OF-8": AO_Open
End Select
End If
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

