Delete previous cell content

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi,

Not sure if this is function or programming?
Question is:
In column F, Row 4, Header is "Do You Require Training?" in row 5 is a
validation list = Yes, No.
In column G, Row 4, Header is " Training Completed?" in row 5 is a
validation list = Yes, No.

If the user has selected Yes in Column F, Row 4 because they did need
training...then they do it...so when they select Yes in Column G, can the Yes
in Column F be automatically deleted.......I have set up a Validation Message
telling the=m to delete previous cell, problem is they don't read it and it
skewing my stats.

Thanks in Anticpation and trust that was clear

Craig
 
Try this short macro. Right click on sheet tab, view code, paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("G:G")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
'Is training complete?
If UCase(Target.Value) = "YES" Then
Application.EnableEvents = False
'Clear out the "need training" cell
Cells(Target.Row, "F").ClearContents
Application.EnableEvents = True
End If
End Sub
 
Thanks Luke....excellent job.....never get disillusioned or disappointed with
this group

Thanks for your time

Craig
 
Back
Top