RobinTMathew
Board Regular
- Joined
- Mar 2, 2010
- Messages
- 88
I'm not proficient at all in VBA coding but I will give it a shot. I've added check boxes into column A. Column B will read "TRUE/FALSE". Column C is an IF statment that will give "Last Date Date and Time Updated" if the Update checkbox is marked in column A.
Problem now is how do I copy the check box all the way down in column A without having to copy and paste or manually insert into each cell?
Also, when ever I toggle the checkbox in, lets say, cell a2 the result will be the date and time in c2. Thats fine but then when I toggle the check box in in cell a3 or a5 for that matter it ends up updating all of the individual date and times with the last toggle. I want each cell to be specific for that event and when the user updated the information for that particular row.
Any ideas?
Problem now is how do I copy the check box all the way down in column A without having to copy and paste or manually insert into each cell?
Also, when ever I toggle the checkbox in, lets say, cell a2 the result will be the date and time in c2. Thats fine but then when I toggle the check box in in cell a3 or a5 for that matter it ends up updating all of the individual date and times with the last toggle. I want each cell to be specific for that event and when the user updated the information for that particular row.
Any ideas?
