I'm not 100% sure, but you may want to try changing:
with box1
to:
with sheet1.box1
Also, consider whether the code you have is on a module or on the shee
or on the workbook, because this will make a difference whe
referencing objects. Also, be doubly sure you have actually changed th
Name of the checkbox to box1 and not the Caption.
I hope this is of some help
--
Message posted from
http://www.ExcelForum.com