Glad you found something useful!

yangyh wrote:

I'd use the checkboxes from the Forms toolbar.
Searching the old threads and found the following information. The
check box
works perfect in my program. Thank you Dave Peterson!!!

================================================== ====

Just add a checkbox to the worksheet.
rightclick on it and choose Format Control
on the Control tab, assign a nice linked cell
(Maybe column A of the row that holds the checkbox???)

Then this linked cell will be true or false depending on the
"checkedness" of
that checkbox.

If you have to have yes/no, you could use a formula in column B (same
row) that
looks like:

=if(a1=true,"yes","no")

And if you find that column A makes the worksheet look ugly, you could
always
hide it when you're done creating the worksheet.

--
yangyh
------------------------------------------------------------------------
yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883
View this thread: http://www.excelforum.com/showthread...hreadid=467265

--

Dave Peterson