Results 1 to 2 of 2

Hiding Columns based on Data validation value

Threaded View

  1. #1
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Hiding Columns based on Data validation value

    This is an easy one - just having a brain fart.

    I have a data validation drop down in a2 with three options: "One", "Two", or "Three"

    Range B1:H1 has random values of either "One","Two", or "Three"

    What I am looking for is an automatic worksheet code that hides any columns, in the B:H range, that does not match the corresponding Data Validation selection. Looking for the trigger to be anytime the data validation is changed. This would also unhide any columns that does match the validation.

    Thanks for any help,
    Last edited by GuruWannaB; 08-02-2021 at 11:05 AM.
    I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!



    Please mark your threads as Solved once it is solved. Check the FAQ's to see how.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display columns in excel based on Data validation list in multiple columns
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2017, 09:17 PM
  2. Replies: 8
    Last Post: 01-23-2015, 02:32 PM
  3. [SOLVED] VBA code for hiding rows based on Data Validation cells
    By jrtdcg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2012, 12:59 PM
  4. [SOLVED] Hiding rows based on Cell Colour & Data Validation Value
    By Mowgli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2012, 09:10 AM
  5. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  6. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  7. [SOLVED] Showing or Hiding rows based on data validation list
    By Magnet Peddler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2006, 04:40 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