"Dave Bryden" wrote in message
...

Many thanks,

Am I correct in thinking that the code would be applied to the worksheet
since this event is specific to the checkbox on this sheet? If the macro
dealt with something that concerned the whole workbook that it would
have workbook focus?


That's right, although clearly controls have to be on a worksheet, there is
no workbook control.

I tried the modified code, while it doesn't generate errors, it also
doesn't put anything in the cell.

It worked with me, so that suggests that the control is not called Box1.


I used the control bar to define the checkbox and while it was showing
as refernce in the formula bar, used namedefine to add the name BOX1,
in the formula bar I have: =EMBED("Forms.CheckBox.1","")


I thin k we have the problem here. You don 't change the name via
NameDefine. The name wikll appear in the Names box, to the left of the
formula bar, and this is is where you should change the name. Slect the
object in design mode and change it n ow and try it again.


If all this still fails to work, mail me the workbook at bob . phillips @
tiscali . co . uk (remove the spaces) and I will fix it.