Using macro to input static date

**Dark Pelican** · 06-28-2011, 01:42 PM

Hi,

I found a piece of code on the internet that input the date into one column upon changing a another; however, I wanted to alter the code so that it would only input the date upon something being entered into the target column and not just any change (at the moment it puts the date in even if I clear all the information). I was also wondering whether it was possible to have the date disappear if the information is deleted.

Here is the current code. I'd appreciate all the help I can get:

Please Login or Register  to view this content.

**ChemistB** · 06-28-2011, 02:09 PM

As per forum rules, your code should be inside code html for ease of reading.

http://www.excelforum.com/forum-rule...rum-rules.html

Try this code

Please Login or Register  to view this content.

**Dark Pelican** · 06-29-2011, 05:25 AM

Thanks for your help, but unfortunately it doesn't work. It does the job initially, as it enters the date in the offset field upon inputting data into column D, and then clears the date if the data is removed; however, after the first time you clear a cell in column D, any further entries do not result in the date being input into the offset column. It is also only possible to have one offset cell cleared, as after the first 'delete', it stops clearing the other offset fields in response to further deletions on data from column D.

Thanks for trying though, it was partially successful.

**TMS** · 06-29-2011, 07:36 AM

Try:

Please Login or Register  to view this content.

Regards

**Dark Pelican** · 06-29-2011, 07:59 AM

Thanks TM Shucks, it works perfectly.

**TMS** · 06-29-2011, 08:19 AM

You're welcome ... but the credit should go to ChemistB, it's his code. I just moved a line.

Thanks for the rep.

If this has answered your question, please mark your thread as Solved.

Regards

**ChemistB** · 06-29-2011, 08:40 AM

Oops, my bad. Thanks for the fix TM.

**TMS** · 06-29-2011, 10:04 AM

@ChemistB: no problem, easily done. TMS

**Dark Pelican** · 07-01-2011, 05:24 AM

Anyway, I've pressed the scales for both of you, so thanks.

Using macro to input static date

LinkBack

Thread Tools

Rate This Thread

Display

Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Re: Using macro to input static date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions