+ Reply to Thread
Results 1 to 4 of 4

Automatically Hide or not Hide columns, based on cell value (to the left)

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Automatically Hide or not Hide columns, based on cell value (to the left)

    Hello, looking for any assistance on setting up this macro that has two drop down lists, in two separate columns. In each drop down list, when a particular selection is made, the column to the right of it either needs to be hidden (will be hidden by default, which is different than the attached for sake of sending a sample), or not hidden to allow for added text.

    I have some basic code in there however not sure how to set up a macro to automatically run based on the selection, versus me actually running the macro (novice here).

    Appreciate any input, thanks so much.
    Sheryl
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,665

    Re: Automatically Hide or not Hide columns, based on cell value (to the left)

    .
    Paste this in the Sheet 1, Sheet Level Module :

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Re: Automatically Hide or not Hide columns, based on cell value (to the left)

    Thank you! I actually have a part two to this that could get more involved so I will mark this thread resolved and submit a new one. Thank you for the quick reply!

    Sheryl

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,665

    Re: Automatically Hide or not Hide columns, based on cell value (to the left)

    You are welcome.

+ 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. Hide Rows/Hide Columns Based on Value in Cell
    By brickwall823 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2015, 02:42 PM
  2. Hide Columns automatically based on date
    By ravisidhu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2015, 01:15 AM
  3. Hide Columns automatically based on year month(YYYY-mm)
    By Jeevhoney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2014, 12:53 AM
  4. Automatically Hide/Unhide Columns Based Dropdown List
    By Kapil.gour in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-27-2012, 07:39 AM
  5. Hide Columns automatically based on date
    By chrisjc19 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-06-2011, 03:32 PM
  6. How do I automatically hide columns in a worksheet based on a cell value?
    By dkhedkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 09:06 PM
  7. Replies: 0
    Last Post: 03-04-2005, 02:43 PM

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