Results 1 to 4 of 4

Hiding columns based on cell value (ListBox)

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    Kyle, Texas
    MS-Off Ver
    Excel 2010
    Posts
    33

    Hiding columns based on cell value (ListBox)

    I have been digging through the forums and can't find what I am looking for.

    I have a very large spreadsheet (Columns A:AK right now...still growing) and I would like to hide columns based on my selection from a ListBox I have in place. Is this possible?

    I have already created Macros that will do this, but I can't assign buttons because when you hide the columns you can't see the button to unhide the columns again. :/

    My ListBox has the names:
    HideRevenue
    ShowRevenue
    HideMax
    ShowMax
    HideVolume
    ShowVolume

    The columns I would like to hide/unhide with each selection are:
    Revenue = I:L
    Max = M:S
    Volume = T,X:Z,AF

    I am not new to Excel, but I am new to VBA which is what I have been trying to use to make this happen. I'm sure there is a way, but can't find it or figure it out on my own.

    Thanks for the help.
    Last edited by Big_Tater; 04-16-2013 at 10:45 PM.
    David

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