Pardon my ignorance as I am new to this wonderful world of scripts.
So far i have this,
Private Sub Worksheet_Change(ByVal Target As Range)
MyVal = Range("B2:B14").Text
With ActiveSheet.Tab
Select Case MyVal
Case ""
.Color = xlColorIndexNone
Case Else
.ColorIndex = 3
End Select
End With
End Sub
All i need to do here is when text is entered in B2 through B14 i need the tab to change from no color to green. With this soon as i put a value in any of the ones in range it changes. I am a Noob so please be gentle.
So far i have this,
Private Sub Worksheet_Change(ByVal Target As Range)
MyVal = Range("B2:B14").Text
With ActiveSheet.Tab
Select Case MyVal
Case ""
.Color = xlColorIndexNone
Case Else
.ColorIndex = 3
End Select
End With
End Sub
All i need to do here is when text is entered in B2 through B14 i need the tab to change from no color to green. With this soon as i put a value in any of the ones in range it changes. I am a Noob so please be gentle.