checkbox on form reset from checkbox on sheet

Hi

I have a checkbox on a worksheet that when you click a from appears and on there is 2 checkboxes but can i add some code to the checkbox on the worksheet to make the checkbox values on the form false when open

I have tried but it just resets the checkbox on the sheet becasue there are the same name

eg checkbox 1 on the worksheet (control toolbar)
Checkbox 1 on the form


Thanks

Why not just use the userform's initialize procedure to set things the way you
want.

Option Explicit
Private Sub UserForm_Initialize()
Me.CheckBox1.Value = False
Me.CheckBox2.Value = False
End Sub




raw wrote:
>
> Hi
>
> I have a checkbox on a worksheet that when you click a from appears and
> on there is 2 checkboxes but can i add some code to the checkbox on the
> worksheet to make the checkbox values on the form false when open
>
> I have tried but it just resets the checkbox on the sheet becasue there
> are the same name
>
> eg checkbox 1 on the worksheet (control toolbar)
> Checkbox 1 on the form
>
> Thanks
>
> --
> raw
> ------------------------------------------------------------------------
> raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
> View this thread: http://www.excelforum.com/showthread...hreadid=490326

--

Dave Peterson