+ Reply to Thread
Results 1 to 2 of 2

Checkbox display with hidden columns

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Hampshire, England
    MS-Off Ver
    2018
    Posts
    43

    Checkbox display with hidden columns

    Hi,

    Looking for some help with showing some columns that are hidden from view and viewable when using a check box.

    I am using the following VBA:

    Sub DisplayTypes_Checkbox()
    Range("C:D").EntireColumn.Hidden = Range("A1").Value
    End Sub

    This does work and completes the job, but it displays a tick in the checkbox when they are hidden, but I want it to be blank and only ticked when they are displayed.

    Is there a way to reverse is so the checkbox is blank if the columns are hidden?

    Thanks.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Checkbox display with hidden columns

    Try
    Please Login or Register  to view this content.
    Also please edit you post to include tags, the # icon in the reply/edit window

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keep hidden columns hidden when entering formulas
    By Darren4164 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2015, 04:08 PM
  2. [SOLVED] hidden or not the text box By checking a checkbox
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-30-2014, 02:32 AM
  3. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  4. Hide checkbox when rows are hidden
    By akaempfe in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 10-08-2012, 01:44 PM
  5. Replies: 0
    Last Post: 09-13-2012, 11:10 AM
  6. Setting CheckBox value based on state of column (hidden/unhidden)
    By leafs in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-13-2011, 10:37 AM
  7. Keeping Hidden Rows/Columns Hidden?
    By DMac in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 08:13 PM

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