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


--
raw
------------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=490326

checkbox on form reset from checkbox on sheet
 

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