How to program on check box
 

Dear all,

I created a check box on the sheet1. I want to use this check box t
control
the Global boolean variable IsHideAllSheets. How can I program t
realize this
function? It seems a little difficult than a single button. Thanks.

Regards,

Davi

--
yangy
-----------------------------------------------------------------------
yangyh's Profile: http://www.excelforum.com/member.php...fo&userid=2688
View this thread: http://www.excelforum.com/showthread.php?threadid=46726

How to program on check box
 

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

How to program on check box
 

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