Maybe you can use a worksheet_change event to look for a change to that cell.

I used a checkbox (named "check box 1") from the Forms toolbar and looked for a
change to A1:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count 1 Then Exit Sub
If Intersect(Me.Range("a1"), Target) Is Nothing Then Exit Sub

Me.CheckBoxes("check box 1").Value = xlOff

End Sub

rightclick on the worksheet tab that should have this behavior. Select view
code. Paste this in.

Adjust the name/range accordingly.

Donkin wrote:

Hi

I have a macro which will input a default value into a cell when run
and I have assigned a check box to the macro.

What I want to do is - If the check box is checked the macro runs and
the default value is inserted (that bits OK).

Now what I want to do is if the user inputs there own value the check
box, unchecks itself to show the default has not been used.

All help appreciated.

--
Donkin
------------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...o&userid=23715
View this thread: http://www.excelforum.com/showthread...hreadid=373897

--

Dave Peterson