This is probably a simple questions, but I have a check box and would like for it to either when checked make certain cells visible or not checked invisible.

does anyone have macros which run behind an active sheet to do this?

Thank you

With Checkbox as chkMyCheckbox - Goto Properties, Events and choose the On Click event. Then pick Code Editor.

Add this inside of that Sub Procedure...

If chkMyCheckbox.value = -1 then 'Checked
     lblMyLabel.visible = True
     txtMyTextbox.visible = True
Else
     lblMyLabel.visible = False
     txtMyTextbox.visible = False
End if

Hope that helps,

Mike


Mike
EchoVue.com

I find I need to add this code to the On Current event of the form as well, since I usually set the default for the controls as Visible = No.



mmcdonal