Checkbox Help

robfo0 · Mar 14th, 2002, 07:01 PM

I found code similar to this in one of NateO's posts, but its not working for me. Am I doing something wrong? I'm trying to get a cell value to change when a check box (not on userform) is checked. I named the check box "Check_box", but nothing happens. Heres the code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Check_box.Value = xlOn Then
Range("AT1").Value = "testtrue"

End If

Thanks

End Sub

NateO · Mar 14th, 2002, 07:26 PM

Rob,

It depends on whether you're using an xldialog or a worksheet control. And if you're using a worksheet control, whether it's a form control or an active x control. If you have a checkbox in your worksheet, you may want to reference the following:

http://www.j-walk.com/ss/excel/tips/tip84.htm

Hope this helps.

Cheers, NateO

[ This Message was edited by: NateO on 2002-03-14 18:27 ]

robfo0 · Mar 15th, 2002, 12:00 AM

Thanks again Nate, active toolbox works nice

thanks for the link too

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:01 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	I found code similar to this in one of NateO's posts, but its not working for me. Am I doing something wrong? I'm trying to get a cell value to change when a check box (not on userform) is checked. I named the check box "Check_box", but nothing happens. Heres the code: Private Sub Worksheet_Change(ByVal Target As Range) If Check_box.Value = xlOn Then Range("AT1").Value = "testtrue" End If Thanks End Sub

Mar 14th, 2002, 07:26 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Rob, It depends on whether you're using an xldialog or a worksheet control. And if you're using a worksheet control, whether it's a form control or an active x control. If you have a checkbox in your worksheet, you may want to reference the following: http://www.j-walk.com/ss/excel/tips/tip84.htm Hope this helps. Cheers, NateO [ This Message was edited by: NateO on 2002-03-14 18:27 ]

Mar 15th, 2002, 12:00 AM	#3
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Thanks again Nate, active toolbox works nice thanks for the link too