Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box
I currently have two buttons. One that will show the hidden rows, the other
that will hide them again. However, i would rather change the two buttons to a check box. So if the check box is "Checked" it will show the hidden cells, but if it is unchecked it will hide the cells again. I assume that is possible. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box
Hi John, Here's some code for a check box (originally sourced from Aaron Blood's highlight.zip file at http://www.xl-logic.com/pages/vba.html): Private Sub CheckBox1_Click() If Sheets(1).CheckBox1 Then 'code for hiding rows else 'code for unhiding rows End If End Sub Nb: depending on your preference/caption in your check box, it may be better around the other way. Or another option is just to turn one of your two buttons into a toggle & delete the other one. Have a look at thread below for ideas to adapt: http://excelforum.com/showthread.php...=toggle+button hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=535769 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions |