What I currently have:
Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case Range("H184"): Range("H8") = Range("G184")
Case Range("H185"): Range("H8") = Range("G185")
Case Range("H186"): Range("H8") = Range("G186")
Case Range("H187"): Range("H8") = Range("G187")
End Select
End Sub
What I'd prefer (I know it's wrong but you get the gist of it):
Private Sub ComboBox1_Change()
Select Case ComboBox1.Value (For i = 4:7)
Case Range("H18%i%"): Range("H8") = Range("G18%i%")
End Select
End Sub
Bookmarks