Checkbox and Satic Date

E

edwardpestian

I have a checkbox that when checked, places "Paid" and the date in a
cell.

IF(V12,"PAID "&TEXT(TODAY(),"mmmm dd")

Once the checkbox is checked, I'd like the date value that it places in
the cell to remain static. In otherwords do not change as the date
changes. Only if I uncheck the cell, and then recheck the cell would
the current date be returned.

Any ideas?

ep
 
A

aidan.heritage

use the change event of the control

if checkbox.value=true then range("V12")=int(now())

should do it for you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I update a date formula only if checkbox changes? 1
set checkbox to enter date when checked and NOT recalculate 4
how do I set up a formula showing the day based on date? 4
protect check box and cells 2
Adding A Date To Adjacent Cell 2
userform date issue 4
Current Month with real date 2
Difference between NOW() and TODAY() 9

Top