Freezing Date via checkbox

**TomTom_BV** · 04-29-2008, 04:10 AM

My dilemna is such:

I have created a form in excel which gives a cost/benefit analysis. The end result is is that a final approver will sign off.

I am a VB very basic user. I have 1 dilemma:

I have a date created field (manual text entry) and today date field (hidden today formula) which gives a 'processing time in days' (datedif function) value

1. I would like to insert a checkbox for the final approver to check once approval has been given. can I link this checked checkbox to the hidden today date formula in order to 'freeze' the date of approval and hence freeze the 'processing days' field.

any help would be much appreciated.

cheers

**tuph** · 05-06-2008, 12:27 AM

Try recording a macro that finds the =TODAY() cell and copies/pastes as values. If it works the way you need it to, you could link the macro to a clipart image for the approver to use.