Hi Antonov.

Assume that checkboxes are on Sheet1 and that the are fromthe Forms toolbar.

(1) Try:

ActiveSheet.CheckBoxes = xlOff

(2)

In the Userform's CheckBox Click event, try something like:

Private Sub CheckBox1_Click()

Sheets("Sheet1").Range("H25").Value = _
Me.CheckBox1.Value
End Sub

---
Regards,
Norman



"antonov" wrote in message
.. .
I have 2 problems with checkboxes:

1. in exel 2003 it it possible to clear the text in the checkboxes I've
placed in my workbook?

2. I have a checkbox in an userform. When I checkit I would like the
result to appear in one of the checkboxes in my workbook. How can I do
that? Checkbox1 is over cell H25.....

Thanks