about check boxe

[pmss]

i am doing some calculations using Macros. I have problem with check boxes. I
want to link with some cells so that i can put my input parameters there for
futher calculation. when i checked the box, link cells must appear and
viceversa.
Thanks

 

[Joel]

Check boxes have a property Linked cell where the links cell will havvew a
value True or False. You can set the lijnked cell either through the
worksheet or VBA.

To set the link cell on the worksheet you need to get into design mode and
change the check box property.


1) view Menu - tool Bars - Control Tool box
2) On toolbar press triangle (Design Mode)
3) Press Property on tool bar (next to triangle).
4) Press Check box. On properrty window set LinkCell to a cell like A1.
5) Exit Design mode by pressing triangle again. Now when you check and
uncheck the check box the linked cell will automatically change.

 

[pmss]

Thanks
Actually i need to have some cells appear when i checked the box so that i
can put my values in the appeared cell.

 

[Joel]

If you go into design mode and double click the check box it will create a
click macro. Put macro code into the click code to make the cells appear or
disappear.

 

[pmss]

Can you please write me a micro code that will help me to do so. I am not
expert on using macros.

 

[Joel]

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
Columns("D").Hidden = True
Else
Columns("D").Hidden = False

End If

End Sub

 

[pmss]

thanks

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
Columns("D").Hidden = True
Else
Columns("D").Hidden = False

End If

End Sub

 

[Rick Rothstein \(MVP - VB\)]

Your Click event code can be shortened to this...

Private Sub CheckBox1_Click()
Columns("D").Hidden = CheckBox1.Value
End Sub

Rick