Question about dates.

[superbeast326]

I have two columns, A and B. Both have 50 rows. Column A is filled entirely with "No". What I want is that the moment I switch a row in Column A to "Yes". I want the row in Column B to store the date that the change was made. Is this possible?

 

[superbeast326]

What suggestions could you provide me if I want to chart out the date.

 

[Peter_SSs]

By the way, why is Ucase used instead of Lcase?

No reason at all, just picked one to use so that the case didn't cause a problem.

What suggestions could you provide me if I want to chart out the date.

I'm not at all strong on charts. Here's one person who is:
http://peltiertech.com/

 

[superbeast326]

Is there a possible line of code that I can use to make the DV cell with a "Yes" into a static cell with the "Yes" value. Will c.value=c.value achieve this?

 

[Peter_SSs]

Is there a possible line of code that I can use to make the DV cell with a "Yes" into a static cell with the "Yes" value. Will c.value=c.value achieve this?

Can you explain in what way my code in post #27 did not already achieve this?

 

[superbeast326]

Sorry, what I meant was, is it possible to turn off the DV Lists that are set to "Yes".

 

[Peter_SSs]

Sorry, what I meant was, is it possible to turn off the DV Lists that are set to "Yes".

If UCase(c.Value) = "YES" Then
    c.Locked = True
    c.Interior.ColorIndex = 35 '<- For testing
    c.Validation.Delete
End If

 

[superbeast326]

One final question, is it possible to use VBA to create DV lists.

 

[Peter_SSs]

One final question, is it possible to use VBA to create DV lists.

Sure. Turn on the macro recorder, create the DV manually then turn off the macro recorder. That should at least give you some code to work on.

 

[superbeast326]

What I meant was, is it possible to hardcode DV lists with VBA?

 

[Peter_SSs]

What I meant was, is it possible to hardcode DV lists with VBA?

As far as I can understand your question, the answer is still the same.
If you don't think that is the answer, then can you be more specific about the problem?