Cheq Boxes (Forms) {Resolved}

brettvba · May 14th, 2002, 11:00 PM

What value do cheq box's have when checked and what value when unchecked
can you make a cheqbox as boolean so its true and false?

_________________

[ This Message was edited by: brettvba on 2002-05-14 17:25 ]

NateO · May 14th, 2002, 11:06 PM

Checked boxes = xlOn
Unchecked boxes = xlOff

Hope this helps.

_________________
Cheers, NateO

[ This Message was edited by: nateo on 2002-05-14 17:17 ]

brettvba · May 14th, 2002, 11:24 PM

Cheers Nate knew you would come through

NateO · May 14th, 2002, 11:33 PM

Cheers Brett! I love it when a plan comes together. I pulled the bit on redefining as xlon is the same amount of key strokes as true.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-14 17:34 ]

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

May 14th, 2002, 11:00 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	What value do cheq box's have when checked and what value when unchecked can you make a cheqbox as boolean so its true and false? _________________ [ This Message was edited by: brettvba on 2002-05-14 17:25 ]

May 14th, 2002, 11:06 PM	#2
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,639	Checked boxes = xlOn Unchecked boxes = xlOff Hope this helps. _________________ Cheers, NateO [ This Message was edited by: nateo on 2002-05-14 17:17 ]

May 14th, 2002, 11:24 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Cheers Nate knew you would come through

May 14th, 2002, 11:33 PM	#4
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,639	Cheers Brett! I love it when a plan comes together. I pulled the bit on redefining as xlon is the same amount of key strokes as true. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-14 17:34 ]