+ Reply to Thread
Results 1 to 3 of 3

Hiding/Showing a Form Control with another Form Control

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    33

    Hiding/Showing a Form Control with another Form Control

    Hey all, thanks for taking time out to look at my problem

    I would like two or more Form Controls hidden on my sheet until a Checkbox is selected. That is, if I check a Checkbox (make it true) then other Checkboxes are revealed. Can this be done?

    In my tralling of past posts I have found some clues, but inevitably they refer to ActiiveX Controls. At this stage I cant interact with an ActiveX (it wont let me click it) - my fault Im not understanding Excel at that level yet.

    I would like to use the Form Control rather than the ActiveX Control at this point, just so I can interact with the True/False value. Can someone help me please, keeping in mind my Excel skills are limited?

    Thanks,

    Kind Regards
    Justin

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Hiding/Showing a Form Control with another Form Control

    I sus[pect that if you cannot click a control then you haven't closed Design View - the set square & ruler icon.

    Add 3 forms comboboxes
    CheckBox1 - Linkedcell is A1
    Assign this macro to CheckBox1


    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    33

    Re: Hiding/Showing a Form Control with another Form Control

    Quote Originally Posted by royUK View Post
    I suspect that if you cannot click a control then you haven't closed Design View - the set square & ruler icon.
    Thank you, I will look for this next time

    The code and explanation you provided worked perfectly. Thank you again.

    Justin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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