Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple CHeck box to view/hide rows
Hi Shelly -
Your code works fine, but needs to be associated with the checkbox's 'click' event (so the very act of clicking the checkbox triggers your code). You do this by inserting your code into a Click event procedure that resides in the module of the worksheet that the checkbox is in. The best way to do that is: 1. Enter Design Mode (show the Control Toolbox and choose [Design Mode]. 2. Right-click the checkbox and choose [View Code]. The worksheet module opens automatically and types a Click-event procedure template as follows: Private Sub Risk_Box_Click() End Sub 3. Insert your code between these two lines. ------- Alternatively, you could copy this slightly modified version into the worksheet module. Again, yours works just fine, but this one is a bit more compact: Private Sub Risk_Box_Click() If Risk_Box.Value = 0 Then Rows("6:9").EntireRow.Hidden = True Else Rows("6:9").EntireRow.Hidden = False End If End Sub -- Jay "Shelly" wrote: I'm trying to create checkbox where if it's checked rows 6-9 show, if it's unchecked they are hidden. I've go the follow, but I must be missing something... -------------------------- Private Sub Risk_Box() Application.ScreenUpdating = False If Risk_Box.Value = 0 Then Range("A6:A9").EntireRow.Hidden = True Else If Risk_Box.Value < 0 Then Range("A6:A9").EntireRow.Hidden = False End If End If Application.ScreenUpdating = True End Sub --------------------------- Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple CHeck box to view/hide rows
Hi Shelly -
Good to hear that you're making progress. Here is a link to address your missing libraries or references problem. Fixing it is frequently easier than you'd think, given the cryptic error message. http://www.cpearson.com/excel/StartupErrors.htm For your particular error, focus first on Step 9. In VBA, go to |Tools|References...| and scan the list for any entries that are stamped with "MISSING". If you find one, and it is not one of the 4 essentials outlined in Step 9, then uncheck it. Exit and restart Excel and see if that cures your problem. Deeper troubleshooting steps are described in the other steps. -- Jay "Shelly" wrote: Thanks, Jay. I was able to finally figure out what was wrong. Excel on my computer is dying. It's giving me an error that libraries or references are missing. Ugh. I'm taken my workbook to another computer - and am back at it again. THANKS! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple CHeck box to view/hide rows
Thanks, Jay. I was able to finally figure out what was wrong. Excel on my
computer is dying. It's giving me an error that libraries or references are missing. Ugh. I'm taken my workbook to another computer - and am back at it again. THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
How to hide negative value view (eg: #######) | Excel Discussion (Misc queries) | |||
Is there a simple procedure to hide rows if a condition is met | Excel Discussion (Misc queries) | |||
simple code hide/show rows with cell = empty, set value or any val | Excel Programming | |||
Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) |