Hi
I have a validation list over 2 cells which when a specific word is selected
from the list then I need the word 'Please specify:' to be shown in another
cell but when any other word is selected from the list is is empty then I
dont want the 'Please specify:' to be visible.

Can anyone help.

I have tried the following but does not work and I dont know why.

Private Sub Worksheet_selectionChange(ByVal Target As Range)

If Target.Address = "G26" Then
If Range("G26").Value = "Other" Then
Range("E28").Value = "Please specify:"
Else
Range("E28").Value = ""
End If
End If

End Sub

Thanks
Noemi