HI
Can you use this?
If you are using a "=EMBED("Forms.CheckBox.1","")"
right click-properties-link cell to "B1" and in C1 type this formula-
=IF(B1=TRUE,A1,"") and copy down.
Regards
Cimjet


"ash3154" wrote in message
...
I need help with VBA:
A1 B1 C1 D1
value checkbox if checked put value in C1, uncheck then clear
value checkbox " "
value checkbox " "

goes on for 500 rows.

Thanks