You might want to add that for your solution she should also eliminate the
VBA code or the formula will be overwritten when the checkbox is unchecked.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
Hi Teresa,

No worries, I often feel like that :-)

Let's assume that it is a forms checkbox (tell me if not). Go to the
checkbox and right-click it. Select the 'Format Control' menu option, and
then the Control tab. In the Cell Link box, put a cell reference in there
and OK out. If you check/uncheck the box, you will see it update your
cell.

Okay, let's assume that you linked to cell H1. In cell I6 add this formula

=IF(H1=TRUE,K33,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teresa" wrote in message
...
Sorry Bob - I didnt understand your response

"Bob Phillips" wrote:

Link the checkbox to a cell, and add a worksheet formula to test that
linked
cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teresa" wrote in message
...
Hi - this sort of works, however if the checkbox is ticked and I
then change the value in K33, l6 doesnt change in tandem,
I have to untick and then tick again - think an extra line is needed
Thanks A Lot for any help

Sub checkbox1_click()

If CheckBox1.Value Then
Range("l6") = Range("k33")
Else
Range("l6") = 0
End If
End Sub