+ Reply to Thread
Results 1 to 6 of 6

Show/HIde Columns using VBA

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    Show/HIde Columns using VBA

    I have 10 check boxes in a sheet and I want that for the range of columns from Column T to Column XR if Checkbox 1 is checked/unchecked then show/hide every 11th column
    if checkbox 2 is checked show/hide every 12th column so if checkbox 1 is checked then Column T,Column AF,Column AR and so on should be shown and unchecked they should be hidden.
    Thought?
    Thanks!

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Show/HIde Columns using VBA

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    Re: Show/HIde Columns using VBA

    John This works somewhat..
    If checkbox1 is checked/unchecked it runs the code but I want it to run for the other checkboxes only when I do the instance for check uncheck..i don't want it to loop through and check for other boxes each time.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Show/HIde Columns using VBA

    Not sure I understand.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    Re: Show/HIde Columns using VBA

    See the sheet attached. I copied the code and applied to buttons.It hides it the first time then does not show them back again.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    Re: Show/HIde Columns using VBA

    OK I think I got it working now !see Attached!
    Attached Files Attached Files

+ 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. Show / Hide columns
    By DBenson1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 05:27 PM
  2. Excel 2008 : Hide/show columns
    By Didieeer in forum Excel General
    Replies: 1
    Last Post: 02-02-2012, 07:36 AM
  3. Hide columns before printing and show after
    By bagulhodoido in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2011, 11:31 PM
  4. Hide Show columns
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2007, 06:10 AM
  5. how can hide and show columns using macro?
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2005, 12:05 AM
  6. how can hide and show columns using macro?
    By Hoshyar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] Show/Hide Columns
    By StephanieH in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-24-2005, 10:05 AM

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