RobinTMathew
Board Regular
- Joined
- Mar 2, 2010
- Messages
- 88
Need help with Check Box.
I've copied and pasted the check box down in column A. I've written a formula in Column C to show the last current date and time updated when checkbox is highlighted.
Problem is that if I click one check box then all of the other checkboxes that are highlighted will reflect the current time.
I want each row to act differently. One row may be left un updated. Another row may have been updated last week and it will show last weeks date. Another row will have been changed today and it will show updated date of today.
It doesn't work like that right now andnot sure what i'm doing wrong.
OR.
Make it even more slick... maybe if a user touches anything in row 1 then cell A1 will show the last update and time.
so forth for all the other rows. Each row is independent.
I am a beginner in VBA and do not know much other than inputting code in. Do not know how to write code.
Thanks
I've copied and pasted the check box down in column A. I've written a formula in Column C to show the last current date and time updated when checkbox is highlighted.
Problem is that if I click one check box then all of the other checkboxes that are highlighted will reflect the current time.
I want each row to act differently. One row may be left un updated. Another row may have been updated last week and it will show last weeks date. Another row will have been changed today and it will show updated date of today.
It doesn't work like that right now andnot sure what i'm doing wrong.
OR.
Make it even more slick... maybe if a user touches anything in row 1 then cell A1 will show the last update and time.
so forth for all the other rows. Each row is independent.
I am a beginner in VBA and do not know much other than inputting code in. Do not know how to write code.
Thanks
