Hi Noemi
Try:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$26" Then
If Range("G26").Value = "Other" Then
Range("E28").Value = "Please specify:"
Else
Range("E28").Value = ""
End If
End If
End Sub
Regards
Shaun
--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile:
http://www.excelforum.com/member.php...o&userid=18610
View this thread:
http://www.excelforum.com/showthread...hreadid=479018