Worksheet_change inquiry

[MrKremrik]

Hi all

How would I have the worksheet_change event enter the date a cell was changed into the adjacent column? For example, if a1 = "Yes", b1 = "2012-08-06".

Thanks much!

 

[Joe4]

Have a look here:
http://www.mrexcel.com/forum/showth...updated-date-only-if-another-cell-has-changed

 

[MrKremrik]

Thanks that was perfect!

 

[Joe4]

Worksheet_Change Event Procedure code only works in specific sheet modules (i.e. "Sheet1"). So you need to paste it into the Sheet module of the Sheet you wish to apply it to.

 

[MrKremrik]

You're right, thanks!

 

[MrKremrik]

One more question. Is it possible to get this code into a worksheet using a macro? I want to have this function in a column after I use a macro to clean up and sort a ton of data.

Thanks!

 

[Joe4]

Do you mean use VBA to create VBA? I have never tried anything like that.
I did find this one link on the topic: http://www.ozgrid.com/forum/showthread.php?t=47229

 

[MrKremrik]

Yes, that's what I wanted it to do. I'm okay if I cannot, though! I read the thread and it didn't really help. Do you know of any other functions in Excel that would allow me to do the same thing as the change event, yet may be executed with a macro?

 

[Joe4]

An "Event Procedure" is just a type of VBA (the terms "VBA" and "macro" are often used interchangeably) that is triggered automatically upon some event happening, like editing a cell, opening a file, selecting a sheet, etc. You can create VBA code in Standard Modules to do the same thing you can in most "Event Procedures", except it will not run automatically (you need to trigger it yourself).

Perhaps is you give us a better idea of exactly what you are trying to accomplish, maybe we would have some other suggestions for you.

 

[MrKremrik]

Okay, this is what I'm trying to use it for: I created a report that is to be pulled out of my company's database that shows every single outstanding invoice. I then run a macro on it to determine which customers are beyond their payment terms of Net30. This macro will also look at the last one of these reports generated and place a "Yes" by all the customers previously contacted. It also gives the option to select a "Yes" from a pull down when you contact someone. This is where I want it to enter the date. If someone enters "Yes" in a column, I want to have Excel show when It was selected in the column to the right. Automatically. :P