Enter Tick Mark

I have a list of names in Column A, rows 2-50.
We meet weekly so, column B, represents the 1st week of the year, Column C being the 2nd week, etc for 52 columns.
I'd like a formula that by pressing the "enter" key, can leave a "check" mark in each appropriate cell to show the individual whose name is on that same row in column A is present for that mtg.
Example: (A-7) is John Doe. By hitting the enter key on (B-7) a check mark will appear to show John Doe was present that week.
Thank you for your help.

Mabe this link will help

http://www.excelforum.com/showthread...highlight=tick

VBA Noob

Try a double click event macro

Please Login or Register  to view this content.

VBA Noob

Glad it hit the (Tick) mark

VBA Noob