Anyone know how to format cells as yes/no boolean logic?
 

Thinking of using XL to create electronic attendance register

I need to check cells on/off (true/false) quickly (mouse click would be
nice)

I would also need to perform simple maths on them using built-in functions

Sounds pretty basic need (Format/Cells/Boolean?), but i can't see it
anywhere

Any ideas? or maybe an attendance register template

A couple of options for a quick browse ..

a. Post by Bob Phillips: A worksheet sub which can insert a checkmark in a
designated range (C2:C100 in Bob's example therein) upon a mouse-click:
http://tinyurl.com/c2j6t

b. A suitable template? at this link:
http://www.wood-wood.com/Downloads/Templates.htm

c. An example set-up described in:
http://tinyurl.com/d9std

Browse this thread for a few ways to insert a checkmark*:
http://tinyurl.com/9u5sk
*Note that you don't really need booleans, just fixed indicators, e.g.: Y/N
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JethroUK©" wrote in message
...
Thinking of using XL to create electronic attendance register

I need to check cells on/off (true/false) quickly (mouse click would be
nice)

I would also need to perform simple maths on them using built-in functions

Sounds pretty basic need (Format/Cells/Boolean?), but i can't see it
anywhere

Any ideas? or maybe an attendance register template

wingdings2 uppercase R works fine - thanx


"Max" wrote in message
...
A couple of options for a quick browse ..

a. Post by Bob Phillips: A worksheet sub which can insert a checkmark in a
designated range (C2:C100 in Bob's example therein) upon a mouse-click:
http://tinyurl.com/c2j6t

b. A suitable template? at this link:
http://www.wood-wood.com/Downloads/Templates.htm

c. An example set-up described in:
http://tinyurl.com/d9std

Browse this thread for a few ways to insert a checkmark*:
http://tinyurl.com/9u5sk
*Note that you don't really need booleans, just fixed indicators, e.g.:
Y/N
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JethroUK©" wrote in message
...
Thinking of using XL to create electronic attendance register

I need to check cells on/off (true/false) quickly (mouse click would be
nice)

I would also need to perform simple maths on them using built-in
functions

Sounds pretty basic need (Format/Cells/Boolean?), but i can't see it
anywhere

Any ideas? or maybe an attendance register template

Glad you found something you liked in that lot <g !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JethroUK©" wrote in message
...
wingdings2 uppercase R works fine - thanx