SpencerRichman
New Member
- Joined
- Feb 15, 2013
- Messages
- 33
- Office Version
- 2021
- Platform
- Windows
I have the code below which contains two separate IF - Else statements. My simple question is this: When Cell C50 changes, will this code run and make the changes based on the current value of cell C50 AND at the same time, will it make changes based on the current value of cell C53? Or will the changes related to cell C53 ONLY happen when the value of cell C53 changes? In other words, are these two IF-Else statements independent of one another, or will a change in Cell C50 OR Cell C53 trigger them both to run?
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("C50") = "Basic" Then
Sheets("Software").Range("F84:G88").Interior.ColorIndex = 2
Else
If Range("C50") = "IQ Mid-Level" Then
Sheets("Software").Range("E84:E88").Interior.ColorIndex = 2
End If
End If
If Range("C53") = "1-5 Bundle" Then
Sheets("Software").Rows("93:93").Hidden = False
Else
If Range("C53") = "6-10 Bundle" Then
Sheets("Software").Rows("93:93").Hidden = True
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("C50") = "Basic" Then
Sheets("Software").Range("F84:G88").Interior.ColorIndex = 2
Else
If Range("C50") = "IQ Mid-Level" Then
Sheets("Software").Range("E84:E88").Interior.ColorIndex = 2
End If
End If
If Range("C53") = "1-5 Bundle" Then
Sheets("Software").Rows("93:93").Hidden = False
Else
If Range("C53") = "6-10 Bundle" Then
Sheets("Software").Rows("93:93").Hidden = True
End If
End If
End Sub