hobbiton73
12-23-2012, 08:05 AM
Hi, I wonder whether someone may be able to help me please.
The section of code below automatically populates column "A" with the date, and column "AS" with the text value "No" when a new record is created withina Excel spreadsheet.
If Not Intersect(Target, Range("B5:AD400", "AF5:AQ400")) Is Nothing Then
If Target.Value <> preValue And Target.Value <> "" Then
Application.EnableEvents = False
With Rows(Target.Row)
.Range("A1").Value = Date
.Range("AS1").Value = "No"
End With
In column "C" I'm using a validation list with the values:
Select
Yes
NoCould someone perhaps tell me please how I may go about changing the functionality, so that as soon as column "A" is populated with the date, the first value from my list i.e. "Select" is automatically populated in column "C"?
Many thanks and kind regards
Chris
The section of code below automatically populates column "A" with the date, and column "AS" with the text value "No" when a new record is created withina Excel spreadsheet.
If Not Intersect(Target, Range("B5:AD400", "AF5:AQ400")) Is Nothing Then
If Target.Value <> preValue And Target.Value <> "" Then
Application.EnableEvents = False
With Rows(Target.Row)
.Range("A1").Value = Date
.Range("AS1").Value = "No"
End With
In column "C" I'm using a validation list with the values:
Select
Yes
NoCould someone perhaps tell me please how I may go about changing the functionality, so that as soon as column "A" is populated with the date, the first value from my list i.e. "Select" is automatically populated in column "C"?
Many thanks and kind regards
Chris