+ Reply to Thread
Results 1 to 2 of 2

Using CASE and hiding a checkbox

  1. #1
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Using CASE and hiding a checkbox

    Hi

    I have some code which hides rows based on the entry into a cell, this works using the "Worksheet_Change(ByVal Target As Range)" and "case", however I can't get that to work when I want to hide a checkbox. Here is a sample of the code:

    Please Login or Register  to view this content.
    The code I have for checkboxes is:
    Please Login or Register  to view this content.
    However I can't get this to work when I include it at the end of a case. I've tried simply hiding the rows where the checkboxes are however they all bunch together and are still semi visible. The checkboxes I'm using are the activexcontrol type.

    Any ideas?

    Thanks

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Using CASE and hiding a checkbox

    try
    Please Login or Register  to view this content.
    you also can hide the row the checkbox is in with the appropriate setting of the checkbox: Design Mode -> RightClick Checkbox -> Format Control -> Properties Tab -> Move and Size with Cells
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1