Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 14th 10, 08:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 208
Default Delete previous cell content

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


  #2   Report Post  
Old May 14th 10, 08:22 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 457
Default Delete previous cell content

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

--
Best Regards,

Luke M
"Craig" wrote in message
...
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



  #3   Report Post  
Old May 14th 10, 09:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 208
Default Delete previous cell content

Thanks Luke....excellent job.....never get disillusioned or disappointed with
this group

Thanks for your time

Craig

"Luke M" wrote:

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

--
Best Regards,

Luke M
"Craig" wrote in message
...
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



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto delete cell content [email protected] Excel Discussion (Misc queries) 1 March 13th 07 01:43 PM
Delete cell content Chuck Neal Excel Discussion (Misc queries) 3 June 14th 06 05:05 PM
Delete Row based off cell content Chuck Neal Excel Discussion (Misc queries) 3 March 29th 06 08:52 PM
Keyboard Macro Just Copies Content of Previous Cell Andy Excel Discussion (Misc queries) 1 October 24th 05 11:54 PM
Hide Cell Content if no data in previous columns Sherry Excel Discussion (Misc queries) 4 February 21st 05 07:27 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017