View Single Post
  #2   Report Post  
ShaunM
 
Posts: n/a
Default update details using vba


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