Excel Check Box Checked, enters date in next field

[ladyck3]

I've created a great tool (thanks Skip) with help that will automatically place a date in a cell when 3 separate sets of progress scores reach 100% each. The cell is conditioned to turn red if past the desired date and green if on time.

Well the thing is, the sections where the user enters the dates which create those 3 sets of scores to 100% each is user defined. Now the end result does place the completed date as the entire project is finished and I think that is sufficient but I've been asked to add a check box and when the step is completed, the user checkes the box. I see two things needed.

Once checked the date is entered in a cell (and then conditionally formatted for on time or past due). However, I'm sure this requires vba right?

That's where I say..HELP!

So if I have a check in cell F12 I want the NOW() function (if NOW()is a VBA function) to place the date (hard coded) into E12. I can lock the cell and conditionally format it but is this possible?

I do have a concern, won't check boxes make this thing grow HUGE in size and add increased potential for corruption? I know its squirrelly at best anyway (backup is your friend).

If so please help.

Thank you in advance..... Oh and I'm sharing the workbook with multiple users.... if that matters.

I'm excited to hear more



LadyCK3
aka: Laurie

 

[SkipVought]

Laurie,

This definitely is a VBA question, so please repost in forum707.

But why a checkbox? Does this user imposed event really add value to the process? Maybe you have not explained complete what the process is, in its entirety.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}