+ Reply to Thread
Results 1 to 3 of 3

Macro cannot hide rows based on cell linked to checkbox

  1. #1
    Registered User
    Join Date
    04-23-2009
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    4

    Macro cannot hide rows based on cell linked to checkbox

    I cannot get my macro to hide rows based on the value of a cell linked to a check box. I got a macro to work when typing directly into a cell, but cannot get it to hide rows when a cell value is updated based on whether a check box is checked or not. So, if the check box is checked, the value in the linked cell becomes TRUE. Here's the code I used to hide a range of rows when typing the word TRUE directly in a cell:

    Please Login or Register  to view this content.
    Can this be modified to work with a cell value based on a formula? I'm a novice with VBA, so any help is appreciated.

    Thanks.

  2. #2
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Macro cannot hide rows based on cell linked to checkbox

    why don't you just apply the macro the the checkbox mate?
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  3. #3
    Registered User
    Join Date
    04-23-2009
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Macro cannot hide rows based on cell linked to checkbox

    OK. Good idea.

    I've assigned a macro to the Form control, but I get run-time error '424': Object required. Here's the code:

    Please Login or Register  to view this content.
    If I use an ActiveX Control it runs perfectly, but I prefer not to use the ActiveX control if at all possible. Any ideas why it doesn't like something about the Form control in the VB script?

    Thanks.
    Last edited by fernaldd; 08-04-2009 at 02:20 PM. Reason: Updated information

+ 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