Make cells visible based on Data Validation criteria

[IJC]

Hi

I have a form and need an option in the form where Text is only visible if Probation is selected.If Probation is selected then all the text in the column "To Be Completed By:" is visible and if Post Probation is selected then there is no visible text in "To Be Completed By:"

I used data validation for selecting Probation or Post Probation....

Thanks

IJC
Excel 2013

[Admin]

Hi IJC,

Welcome to ExcelFox !!

PFA.

[IJC]

That is excellent. Thank you

Is there a way to protect the cells which have text in them (column "To Be Completed By:" ). I do not want anyone to delete the text from within these cells as at the moment the text can be deleted.Can the cells have a password or something which stops the text from being deleted without affecting the dropdown list you set up with code


Thanks again

[Admin]

Replace the existing code with the following

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address(0, 0) <> "K6" Then Exit Sub
    
    
    Const PassWD    As String = "pass"
    
    Me.Unprotect PassWD
    
    If InStr(1, Target.Value, "post", 1) Then
        Range("l10").Resize(Me.UsedRange.Rows.Count).Font.Color = Target.Interior.Color
    Else
        Range("l10").Resize(Me.UsedRange.Rows.Count).Font.Color = Target.Font.Color
    End If
    
    Me.Cells.Locked = False
    Me.Range("l10").Resize(Me.UsedRange.Rows.Count, 3).Locked = True ',3 because the columns are merged
    Me.Protect PassWD
    
End Sub

[IJC]

Thank you and appreciated

IJC