If your checkboxes are linked to a cell, you should be able to use a
worksheet change event for the time stamp.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"pkohler" wrote in
message ...

Okay,

So I'm at a loss. I am trying to create a project checklist (why we
don't use MS Project is a mystery to me).

The problem is that I need to put a checkbox for each item (Row) on the
sheet, and when that checkbox is clicked I need it to time stamp the
neighboring cell. I have no problem doing it one cell at a time. The
issue is that using my current method I would have to write a macro for
each checkbox (over 500 total).

I am using the checkbox from the forms toolbar not the control toolbar.
Any suggestions?

Thanks in advance!!!


--
pkohler
------------------------------------------------------------------------
pkohler's Profile:
http://www.excelforum.com/member.php...fo&userid=8919
View this thread: http://www.excelforum.com/showthread...hreadid=383862