Control Toolbox
 

I know how to make a Checkbox and Option button, but I don't know how
to activate them. I can get the Checkbox on the spreadsheet, but I
can't click it to put the check in it.

What am I doing wrong?

Thanks.

Chip

Control Toolbox
 

you need to double click the box and give it some code to perform should
it be checked for example

if you make a FORM - check box
you need it to right click and format control and give a cell link
value.

so lets say you asign A1 to it the you will notice a1 will = true or
flase depending on the check or uncheck then you could write a formula
saying
=if(A1=true,"check box is checked","check box is unchecked")

if you make a control toolbox xhexk box
double click it and asign some code
example
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Range("A2") = "checked"
Else
Range("a2") = "unchecked"
End If
End Sub


hope this helps


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=559515

Control Toolbox
 

Perhaps you are still in "Design Mode"

Click on the design mode button to get out of that mode.


Gord Dibben MS Excel MVP

On 7 Jul 2006 14:45:41 -0700, " wrote:

I know how to make a Checkbox and Option button, but I don't know how
to activate them. I can get the Checkbox on the spreadsheet, but I
can't click it to put the check in it.

What am I doing wrong?

Thanks.

Chip

Control Toolbox
 

Yes, this was the problem.

Thanks.


Gord Dibben wrote:
Perhaps you are still in "Design Mode"

Click on the design mode button to get out of that mode.


Gord Dibben MS Excel MVP

On 7 Jul 2006 14:45:41 -0700, " wrote:

I know how to make a Checkbox and Option button, but I don't know how
to activate them. I can get the Checkbox on the spreadsheet, but I
can't click it to put the check in it.

What am I doing wrong?

Thanks.

Chip